L21-Use a SQL Warehouse in Azure Databricks

DP-203-Labs-21

SQL is an industry-standard language for querying and manipulating data. Many data analysts perform data analytics by using SQL to query tables in a relational database. Azure Databricks includes SQL functionality that builds on Spark and Delta Lake technologies to provide a relational database layer over files in a data lake.

Before you start

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

Review the What is data warehousing on Azure Databricks? article in the Azure Synapse Analytics documentation.

View and start a SQL Warehouse

Create a database schema

Create a table

Create a query

Create a dashboard