CODEWITHSUNDEEP
azureazure-synapseazure-synapse-analytics
Ahan
Ahan

Reputation: 21

Need help troubleshooting copy activity in Synapse

I am trying to copy data from ADLS Gen 2, an excel file , into a database created in sql serverless pool, through copy activity. I am using the auto-create table option, but the pipeline fails to run with the following error :

Operation on target Copy_oe4 failed: ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'Incorrect syntax near 'HEAP'.',Source=,''Type=System.Data.SqlClient.SqlException,Message=Incorrect syntax near 'HEAP'.,Source=.Net SqlClient Data Provider,SqlErrorNumber=102,Class=15,ErrorCode=-2146232060,State=1,Errors=[{Class=15,Number=102,State=1,Message=Incorrect syntax near 'HEAP'.,},],'

I tried recreating the datasets and the pipeline as well.

Upvotes: 0

Views: 592

Answers (1)

Aswin
Aswin

Reputation: 7156

In Synapse SQL Serverless pool, you cannot create tables. You can create only external tables that reference data stored in external storage, such as Azure Data Lake Storage Gen2. Therefore, you cannot copy the data to serverless SQL pool. This is the reason, you get the error like A database operation failed with the following error: 'Incorrect syntax near 'HEAP'.' in Azure Synapse Analytics pipeline.

Refer MS document on creating external tables in synapse serverless SQL pool.

Upvotes: 0

Related Questions