Unable to see final table in AzureSQL after successful sync

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

After successfully syncing data from a CSV file to MSSQL in AzureSQL as the destination database, the final table is not visible and only a raw table in the airbyte_internal schema is present. How can I view the final table?


Question

Hello, I’m trying to create connection from file(csv) to mssql. I created source and destinations and started the sync, then it is done successfully but I cannot see the final table, there is just raw table in airbyte_internal schema. Note: I am using AzureSQL as destination database. What should I do to see final table?


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["csv-file", "mssql", "sync", "azure-sql", "final-table", "airbyte-internal-schema"]
2

Okey I found that the relevant document. https://docs.airbyte.com/integrations/destinations/mssql-migrations

3

This feature is deleted in version 1.0.0

4

<@U072DU1HJUU> the version 1.0.0 uses Destination V2 (typing and deduping) method to create tables in MSSQL. Are you able to find the tables now?

5

I found the raw table. However, I think the normalized tables will be created in the same way as done in postgres, but now I see that the mssql destination does not currently provide a “normalization” feature (https://github.com/airbytehq/airbyte/discussions/37010|source).