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. These articles can help you get started.

Basic Databricks SQL concepts

To start, familiarize yourself with some basic Databricks SQL concepts. See Databricks SQL concepts.

Interact with sample dashboards

Then, learn how to import and use dashboards in the Databricks SQL Dashboard Samples Gallery that visualize queries. See Tutorial: Use sample dashboards in Databricks SQL.

Visualize queries and create a dashboard

Next, use the SQL editor to execute queries, visualize the results, and create a dashboard. See Tutorial: Use SQL editor to query visualize data.

Use Databricks SQL in a Databricks job

Next, use the SQL task type in a Databricks job, allowing you to create, schedule, operate, and monitor workflows that include Databricks SQL objects such as queries, dashboards, and alerts. See Tutorial: Use Databricks SQL in a Databricks job.

Use COPY INTO to load data

Next, learn how to use COPY INTO in Databricks SQL. See Tutorial: Use COPY INTO with Databricks SQL.

Create a SQL warehouse

To create a SQL warehouse, see Configure SQL warehouse.

Work with technology partners

You can also connect your Databricks workspace to a BI and visualization partner solution using Partner Connect. See Connect to BI partners using Partner Connect.