Databricks SQL queries and dashboards

Databricks Concepts

Kevin Barlow

Data Practitioner

Databricks SQL Assets

Databricks SQL Assets - Query Only

Databricks SQL Assets - Query and Visuals

Databricks SQL Visualization UI

Databricks SQL Assets - Queries and Visuals

Databricks SQL Assets - Complete

Example Databricks SQL Dashboard

Filters

Interactive query / dashboard components that allow the user to reduce the size of the result dataset
Works on the client-side, so is very fast
Supports single select, multi-select, text fields, and date / time pickers

Databricks SQL Filters

SELECT *
FROM nyctaxi.trips
WHERE pickup_zip = 10103
AND dropoff_zip = 10023

Parameters

More flexible than filters, and supports more kinds of selectors
Allow the user to provide a value that is input into the underlying SQL query text
Created in the query by using the {{ }} syntax

Databricks SQL Filter and Parameters

SELECT *
FROM nyctaxi.trips
WHERE pickup_zip = 10103
AND dropoff_zip = 10023
AND {{ nullCheck }} IS NOT NULL

Databricks Concepts