Cloud Architecture

Azure Synapse Serverless SQL on Data Lake

Cloud Architecture diagram · made in Skemio

Architecture diagram showing Analysts and BI tools querying Azure Synapse Serverless SQL endpoint using OPENROWSET against Parquet and CSV files in Azure Data Lake Storage Gen2.
Architecture diagram showing Analysts and BI tools querying Azure Synapse Serverless SQL endpoint using OPENROWSET against Parquet and CSV files in Azure Data Lake Storage Gen2.
Open it in SkemioMake your own

What it shows

  • Serverless SQL queries files directly in ADLS Gen2 using OPENROWSET
  • Charges are based strictly on processed data volume ($5 per TB scanned)
  • Supports views and external tables to mask raw storage paths from analysts

The takeaway

Synapse Serverless turns raw cloud storage into an instant, pay-per-query SQL warehouse.

More cloud architecture diagrams