top of page

Query files using a serverless SQL pool

Writer's picture: Harini MallawaarachchiHarini Mallawaarachchi

SQL is probably the most used language for working with data in the world. Most data analysts are proficient in using SQL queries to retrieve, filter, and aggregate data - most commonly in relational databases. As organizations increasingly take advantage of scalable file storage to create data lakes, SQL is often still the preferred choice for querying the data. Azure Synapse Analytics provides serverless SQL pools that enable you to decouple the SQL query engine from the data storage and run queries against data files in common file formats such as delimited text and Parquet.



Before you start

You'll need an Azure subscription in which you have administrative-level access.

Review the Serverless SQL pool in Azure Synapse Analytics article in the Azure Synapse Analytics.



Query data in files

Access external data in a database





6 views0 comments

Recent Posts

See All

L20-Use Delta Lake in Azure Databricks

DP-203-Labs-20 Delta Lake is an open source project to build a transactional data storage layer for Spark on top of a data lake. Delta...

Comentários


bottom of page