Error in read parquet files from extrenal storage with Synapse Analytics

Shlomi Lanton 56 Reputation points
2022-10-30T19:05:56.33+00:00

Hey,

I'm using Synapse Analytics to query parquet files in blob storage. once every few queries (could be the exact same query), I get the error

Error handling external file: 'IO request completed with an error. ERROR = 0x0000000C'. File/External table name: 'https://xxxx.blob.core.windows.net/container/service_id=1111/month=10/partition_version=last/part-0.parquet'.  
  

Note that it could be that the file is been updated while the query is running. Could it be the cause for this error? What can I do to prevent it?

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.
4,539 questions
{count} votes