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 pipeline fails on the script 'Create table'. It is trying to create a table that already exists. Any ideas?
1 Reply
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.
