Hi all, I am trying to rename a table in the strea...
# troubleshooting
a
Hi all, I am trying to rename a table in the stream called
A-test_data
, where A is the database from my tap-mysql and my target is target-snowflake, to
table_one
I have tried to use Alias in my stream_maps config for target-snowflake and I keep getting the error
Copy code
singer_sdk.exceptions.RecordsWithoutSchemaException: A record for stream 'internal-ticketing_data' was encountered before a corresponding schema. Check that the Tap correctly implements the Singer spec.
and my meltano.yml was
Copy code
- name: target-snowflake
    variant: meltanolabs
    pip_url: meltanolabs-target-snowflake
    config:
      stream_maps:
        A-test_data:
          __filter__: "'0000' not in date"
          __alias__: table_one
Would anyone be able to help me with why alias is not working? I then tried
Copy code
- name: target-snowflake
    variant: meltanolabs
    pip_url: meltanolabs-target-snowflake
    config:
      stream_maps:
        table_one:
          __source__: A-test_data
          __filter__: "'0000' not in date"
        __else__: __NULL__
However this would create the
table_one
table in snowflake and populate it with values, it would also create an empty table
test_data
which we do not want created. Does anyone know how to avoid creating the extra empty table in this case?