Hi everyone. Has anyone tried using airbyte to EL data (not necessary doing a normalisation) into an Azure Synapse Analytics dedicated pool? I can get as far as this error when trying to set up the

MS SQL Server

connector:

State code: S0001; Error code: 104467; Message: Enforced unique constraints are not supported. To create an unenforced unique constraint you must include the NOT ENFORCED syntax as part of your statement.

Hey there, were you trying to sync from SQL Server into Azure Synapse? Currently we have an open issue for an Azure Synapse destination connector: https://github.com/airbytehq/airbyte/issues/2149

Thanks for the response @Sunny Hashmi (Airbyte). I did indeed want to use the Azure Synapse Analytics destination. Thanks for providing the issue I can track until it’s ready 👍