Synapse COPY INTO performance with nvarchar(max)
I have an Azure Synapse dedicated pool. I use COPY INTO to read CSV files from Azure blob storage into an existing table. It can consistently load 3Gb / 27M rows in under 10 minutes.
I have an Azure Synapse dedicated pool. I use COPY INTO to read CSV files from Azure blob storage into an existing table. It can consistently load 3Gb / 27M rows in under 10 minutes.