Category: No category

Azure Synapse, No category

Exporting data to PARQUET file and ADLS Gen2 using Azure Synapse Serverless

Exporting query data is quite simple as one-two-three: One: define your file format CREATE EXTERNAL FILE FORMAT parquetfile1 WITH ( FORMAT_TYPE = PARQUET, DATA_COMPRESSION = ‘’ );   Two: define your file location (note: you should have read/write/list permission the path) CREATE EXTERNAL DATA SOURCE ADLS_DS WITH( LOCATION = ‘abfss://’)Czytaj dalej / Read more