top of page

L21-Use a SQL Warehouse in Azure Databricks

Writer's picture: Harini MallawaarachchiHarini Mallawaarachchi

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




1 view0 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...

L19-Use Spark in Azure Databricks

DP-203-Labs-19 Azure Databricks is a Microsoft Azure-based version of the popular open-source Databricks platform. Azure Databricks is...

תגובות


bottom of page