Get started with data warehousing using Databricks SQL

If you're a data analyst who works primarily with SQL queries and your favorite BI tools, Databricks SQL provides an intuitive environment for running ad-hoc queries and creating dashboards on data stored in your data lake.

Learn the basics

Step	Description
Basic Databricks SQL concepts	Familiarize yourself with the core interfaces, query concepts, data management tools, and authentication model in Databricks SQL.
Data warehousing architecture	Understand lakehouse architecture, medallion layers, and data modeling approaches for building a data warehouse.

Build your first assets

Step	Description
Explore sample dashboards	Import and interact with dashboards from the Dashboard Samples Gallery that visualize queries on sample data.
Create an AI/BI dashboard	Build a dashboard to explore data and share insights with your team using AI-assisted authoring and an enhanced visualization library.
Create a SQL warehouse	Provision a SQL warehouse to start running queries on your data.

Connect and automate

Step	Description
Use Databricks SQL with a notebook	Attach a notebook to a SQL warehouse to run SQL alongside Python, Scala, or R.
Load data with COPY INTO	Use COPY INTO to ingest data from cloud object storage into your Databricks SQL tables.
Use Databricks SQL in a job	Create, schedule, and monitor workflows that include Databricks SQL queries, dashboards, and alerts.
Connect BI tools with Partner Connect	Connect your Databricks workspace to a BI and visualization partner solution.