Hi All. running into an issue on Airbyte OSS. hav...
# replication-troubleshooting
j
Hi All. running into an issue on Airbyte OSS. have been syncing 2 tables from MS SQL to snowflake on full|overwrite. Assume these are customer & event tables in MS SQL to be synced. After syncing: Event => event & _airbyte_raw_event tables are generated on snowflake Customer => customer & _airbyte_raw_cutomer tables are generated, however, additional account_ab2 & account_ab3 views are generated in snowflake. Have tested other sources such as postgres, no views are generated on the destination. Does any know why views are generated on the destination? Based on logs, seems instead of ctes, normalization step generated views. Logs looks like below:
Generating airbyte_ctes/AIRBYTE/CUSTOMER_AB1.sql from CUSTOMER
Generating airbyte_views/AIRBYTE/CUSTOMER_AB2.sql from CUSTOMER
Generating airbyte_views/AIRBYTE/CUSTOMER_AB3.sql from CUSTOMER
Generating airbyte_tables/AIRBYTE/ACCOUNT.sql from CUSTOMER
Generating airbyte_ctes/AIRBYTE/EVENT_AB1.sql from Event
Generating airbyte_ctes/AIRBYTE/EVENT_AB2.sql from Event
Generating airbyte_ctes/AIRBYTE/EVENT_AB3.sql from Event
Generating airbyte_tables/AIRBYTE/EVENT.sql from Event
✍️ 1
u
@[DEPRECATED] Marcos Marx turned this message into Zendesk ticket 2880 to ensure timely resolution!
u
Hi! Could you please provide your full logs? That will help me debug the issue, currently I don't have enough information to help!