Forum Discussion
Azure Pipeline Template times out when trying to create a table that already exists.
Hi All, I have set up an Azure Pipeline using the template 'Copy Dataverse data into Azure SQL using Synapse Link'. I have set this up successfully on another database / environment. This time, the p...
The pipeline fails because the template default script always tries to create the target table, even if it already exists. To fix this, you need to adjust the pre-copy script or pipeline logic to use IF NOT EXISTS (or DROP TABLE IF EXISTS before creation), or disable the “Create table” step if the schema is already provisioned.