שתף באמצעות


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.

Note

Databricks SQL Serverless is not available in Azure China. Databricks SQL is not available in Azure Government regions.

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 Azure Databricks workspace to a BI and visualization partner solution.