Hello, I want to move data from mssql to snowflake...
# troubleshooting
z
Hello, I want to move data from mssql to snowflake and have troubles setting the schema mapping up. The
tap_stream_id
comes as
<schema name>-<table name>
:
Copy code
Visiting metadata node for tap_stream_id 'one-Table1', breadcrumb '['properties', 'Column1']'
The loader (
target-snowflake
) schema mapping config:
Copy code
schema_mapping:
  one-Table1:
    target_schema: ONE_SH
The end result is:
Copy code
name=target_snowflake level=WARNING message=No columns discovered in the schema "SOMETHING.ONE_SH"
Am I missing something 🤔? The ideal solution for me would be to get the schemas created in Snowflake (if those do no exist) with the same name as the MS SQL source schemas.