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 = ‘org.apache.hadoop.io.compress.SnappyCodec’ );   Two: define your file location (note: you should have read/write/list permission the path) CREATE EXTERNAL DATA SOURCE ADLS_DS WITH( LOCATION = ‘abfss://synapse@deltapoc0storage0dest.dfs.core.windows.net’)Czytaj dalej / Read more