top of page
Writer's pictureHarini Mallawaarachchi

Query files using a serverless SQL pool


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

Comments


bottom of page