Azure Synapse Parquet File Sink to Synapse Serverless SQL Pool Error

SoonJoo@Genting 216 Reputation points
2021-11-24T02:20:10.33+00:00

I tried to copy a parquet data file to my Synapse Serverless SQL Pool and getting the following error:

A database operation failed with the following error: 'External table 'dbo' is not accessible because location does not exist or it is used by another process.' External table 'dbo' is not accessible because location does not exist or it is used by another process., SqlErrorNumber=16562,Class=16,State=1, Activity ID: bd9a507d-2d01-46e6-abee-d49ad814cc89

The table was created by using the Synapse UI using the create external table options. After I've created the table, I tried to sink another updated parquet file to the table.

Is this operation permitted?

Thanks!

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,625 questions
{count} votes