I have a large 700 GB CSV file in an Azure Blob Container. I am using Azure Synapse to transform column names, and some data and sink it in a table. I am unable to sink it to the Table Storage in another Azure Data Lake Storage account.
Why can't I choose an Azure Table Storage ? Do I have to add an intermittent Parquet layer to store data between file to table ? Please assist.
Why can't I choose an Azure Table Storage? Do I have to add an intermittent Parquet layer to store data between file to table?
Azure table storage is not supported in sink. Please find the below supported sink types as given in the documentation accordingly: -
https://learn.microsoft.com/en-us/azure/data-factory/data-flow-sink
You can use copy data tool to transform data from azure blob storage to Table storage.
Kindly refer the below documentation link given for copying and transforming the data in Azure Blob storage by using Azure Data Factory or Azure Synapse Analytics
https://learn.microsoft.com/en-us/azure/data-factory/connector-azure-blob-storage?tabs=data-factory