Manage
Production
Analytics with
Databricks SQL
Module 07
©2023 Databricks Inc. — All rights reserved 1
Module Agenda
Manage Production Analytics with Databricks SQL
Introduction to Databricks SQL
DE 7.1 – Navigating Databricks SQL and attaching to SQL Warehouse
DE 7.2 – Last Mile ETL with Databricks SQL
©2023 Databricks Inc. — All rights reserved 2
Introduction to
Databricks SQL
©2023 Databricks Inc. — All rights reserved 3
Databricks SQL
Delivering analytics on the freshest data with data warehouse performance and
data lake economics
• Better price/performance than other cloud data warehouses
• Simplify discovery and sharing of new insights
• Connect to familiar BI tools, like Tableau or Power BI
• Simplified administration and governance
©2022 Databricks Inc. — All rights reserved 4
Better price / performance
Run SQL queries on your lakehouse and analyze your freshest data with up
to 6x better price/performance than traditional cloud data warehouses.
Source: Performance Benchmark with Barcelona Supercomputing Center
©2022 Databricks Inc. — All rights reserved 5
Broad integration with BI tools
Connect your preferred BI tools with optimized connectors that provide fast
performance, low latency, and high user conconcurrency to your data lake for
your existing BI tools.
Coming soon:
©2022 Databricks Inc. — All rights reserved 6
A new home for data analysts
Enable data analysts to quickly
perform ad-hoc and
exploratory data analysis, with a
new SQL query editor,
visualizations and dashboards.
Automatic alerts can be triggered
for critical changes, allowing to
respond to business needs faster.
©2022 Databricks Inc. — All rights reserved
Simple administration and governance
Quickly setup SQL / BI
optimized compute with SQL
warehouses. Databricks
automatically determines
instance types and
configuration for the best
price/performance. Then, easily
manage usage, perform quick
auditing, and troubleshooting
with query history.
©2022 Databricks Inc. — All rights reserved
Use Cases
Connect existing BI tools to one Collaboratively explore the Build data-enhanced
source of truth for all your data latest and freshest data applications
Maximize existing investments by Respond to business needs faster Build rich and custom data
connecting your preferred BI tools to with a self-served experience enhanced applications for your
your data lake with Databricks SQL designed for every analysts in your own organization or your
Warehouses. Re-engineered and organization. Databricks SQL Analytics customers. Benefit from the ease
optimized connectors ensure fast provides a simple and secure access of connectivity, management, and
performance, low latency, and high user to data, ability to create or reuse SQL better price / performance of
concurrency to your data lake. Now queries to analyze the data that sits Databricks SQL Analytics to
analysts can use the best tool for the job directly on your data lake, and quickly simplify development of
on one single source of truth for your mock-up and iterate on visualizations data-enhanced applications at
data while minimizing more ETL and data and dashboards that fit best the scale, all served from your data
silos. business. lake.
©2022 Databricks Inc. — All rights reserved
Navigating to Databricks SQL Persona
10
©2023 Databricks Inc. — All rights reserved
An SQL warehouse is a computation resource that lets you
SQL Warehouse run SQL commands on objects within Databricks SQL
To reduce latency, increase cluster size
Scale to handle more concurrent users
Serverless endpoints starts instantly
Tags for tracking in cloud provider
New features and release
11
©2023 Databricks Inc. — All rights reserved
Import Existing Dashboard
©2023 Databricks Inc. — All rights reserved 12
Add Visualization to Dashboard
©2023 Databricks Inc. — All rights reserved 13
Run a SQL query
©2023 Databricks Inc. — All rights reserved 14
Demo: Navigating Databricks SQL and
Attaching to Warehouses
• Navigate to Databricks SQL
• Create SQL Warehouse
• Load a sample dashboard
• Attach to a SQL Warehouse
©2023 Databricks Inc. — All rights reserved 15
Lab: Run a Databricks SQL Query
• Create a sample query
• Execute sample query
• Add a visualization
• Modify query and rerun
• Create a new query
©2023 Databricks Inc. — All rights reserved 16
Lab: Last Mile ETL with Databricks SQL
• Create Queries
• Set a Query Refresh Schedule
• Create a Bar Graph Visualization
• Create a New Dashboard
• Add a Line Plot Visualization to your Dashboard
• Create a Query to Report Summary Statistics
• Add the Summary Table to your Dashboard
• Review and Refresh your Dashboard
• Share your Dashboard
• Set Up an Alert and Review Alert Destination Options
©2023 Databricks Inc. — All rights reserved 17
©2023 Databricks Inc. — All rights reserved 18
