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.
To start, familiarize yourself with some basic Databricks SQL concepts. See Databricks SQL concepts.
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.
Next, use the SQL editor to execute queries, visualize the results, and create a dashboard. See Tutorial: Use SQL editor to query visualize data.
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.
Next, learn how to use COPY INTO in Databricks SQL. See Tutorial: Use COPY INTO with Databricks SQL.
To create a SQL warehouse, see Configure SQL warehouse.
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.