anish_singla
06/18/2024, 7:03 PMA-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
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
- 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
- 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?