Hi guys! I am trying to integrate with Azure Synap...
# replication-troubleshootingc
Christopher Teljstedt
10/21/2022, 11:59 AMHi guys! I am trying to integrate with Azure Synapse, however I cannot get it to work. See image attached.
It is essentially the same problem described here: https://discuss.airbyte.io/t/issues-connecting-to-azure-synapse/2720 and I tried to provide the same insight there as here. I pinned down the error to PRIMARY KEY not being compatible in Azure Synapse without using NONCLUSTERED NOT ENFORCED.
I just started with Airbytes today and have no experience in contributing to a project. I also created a commit that probably is completely wrong and breaking for other MS SQL integrations. What would be the best way to go about getting support for Azure Synapse? Is there anyone willing to assist helping me getting the MSSQL destination working for Azure Synapse?
✍️ 1
Christopher Teljstedt
10/21/2022, 12:01 PMHere are a reference to MS documentation on the issue: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-table-constraints
Christopher Teljstedt
10/21/2022, 12:02 PMA workaround is for me to create a normal SQL database and copy it to the warehouse, but ideally I would like to load data directly.
u
user
10/21/2022, 12:23 PM@[DEPRECATED] Marcos Marx turned this thread into Zendesk ticket 3009 to ensure timely resolution!
h
Harshith (Airbyte)
10/21/2022, 1:00 PMHey kindly create a github issue so that team can look into it
c
Christopher Teljstedt
10/21/2022, 1:15 PM@Harshith (Airbyte) Thanks
https://github.com/airbytehq/airbyte/issues/18297
u
user
10/24/2022, 9:26 AMThank you team will look into it and get back soon
12 Views