How to query Parquet files in Synapse with OPENROWSET
Learn how to query Parquet files in Azure Synapse with OPENROWSET: automatic schema, the WITH clause and filepath() to …
4 min
16 Jul 2026
How to set cost limits in Synapse SQL Serverless
Learn how to set cost limits in Synapse SQL Serverless: measure data processed, apply daily caps and cut the bill with …
5 min
13 Jul 2026
How to load data with COPY INTO in Azure Synapse
Learn to load CSV and Parquet files into a Dedicated SQL Pool in Azure Synapse using the COPY INTO command, step by ste…
4 min
10 Jul 2026
How to Create a VIEW in Synapse Serverless SQL Pool
Learn how to create a VIEW in the Azure Synapse serverless SQL pool with OPENROWSET to query Data Lake files without re…
4 min
07 Jul 2026
How to query partitioned data in Synapse serverless SQL
Learn how to query partitioned data in Azure Synapse serverless SQL with OPENROWSET and filepath(), scanning only the f…
4 min
06 Jul 2026
How to Create External Tables with CETAS in Azure Synapse
Learn how to use CETAS in Azure Synapse to create Parquet External Tables from your Data Lake, step by step, with a ser…
4 min
05 Jul 2026
Synapse Pipelines vs Azure Data Factory: when to use each
Synapse has integrated pipelines based on ADF. Understand the differences, overlaps and when it makes sense to use each…
1 min
01 May 2026
Spark Pools in Synapse: integrated distributed processing
Spark Pools in Synapse let you run PySpark notebooks and Spark pipelines directly in the Synapse ecosystem, with native…
1 min
08 Dec 2025
Synapse Link for Cosmos DB: operational analytics without ETL
Synapse Link creates a channel for direct analysis of operational Cosmos DB data into Synapse, with no ETL pipelines an…
1 min
15 Jul 2025
Dedicated SQL Pool in Synapse: data distribution and optimization
The Dedicated SQL Pool is the Synapse data warehousing engine with parallel distribution. The choice of data distributi…
1 min
19 Feb 2025
Serverless SQL in Synapse: query the Data Lake without infrastructure
The serverless SQL pool lets you query Parquet, CSV and JSON files directly on ADLS Gen2 with standard T-SQL, without p…
1 min
26 Sep 2024