search

airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
15.4k stars 3.97k forks source link

Issues while connecting to Azure Synapse #4503

Open vaibhawvipul opened 3 years ago

vaibhawvipul commented 3 years ago

Unable to connect to azure synapse provisioned sql pool.

Steps -

  1. Followed the UI to setup MS SQL Server Destination
  2. Wrote the necessary arguments in the text fields
  3. Hit submit

Screenshot - https://user-images.githubusercontent.com/10995936/124288835-43c88680-db6f-11eb-89c4-98647bd97e64.png

airbyte

Error - 


Could not connect with provided configuration. Enforced unique constraints are not supported. To create an unenforced unique constraint you must include the NOT ENFORCED syntax as part of your statement.```
sherifnada commented 3 years ago

@vaibhawvipul is synapse fully compatible with MSSQL?

vaibhawvipul commented 3 years ago

@vaibhawvipul is synapse fully compatible with MSSQL?

https://docs.airbyte.io/integrations/destinations/mssql

According to this document, it should be. It doesn't mention experimental version. @sherifnada

boggdan95 commented 1 year ago

Any updates? Were you able to connect to Azure Synapse? @vaibhawvipul

chte commented 1 year ago

I also face this issue with Azure Synapse