Databricks SQL queries and dashboards

Concetti di Databricks

Kevin Barlow

Data Practitioner

Databricks SQL Assets

Databricks SQL Assets - Query Only

Concetti di Databricks

Databricks SQL Assets

Databricks SQL Assets - Query and Visuals

Concetti di Databricks

Visualizations

  • Lightweight, in-platform visualizations
  • Support for standard visual types
  • Ability to quickly comprehend data in a graphical way

Databricks SQL Visualization UI

Concetti di Databricks

Databricks SQL Assets

Databricks SQL Assets - Queries and Visuals

Concetti di Databricks

Databricks SQL Assets

Databricks SQL Assets - Complete

Concetti di Databricks

Dashboards

  • Lightweight, easily created dashboards
  • Ability to share and govern across your organization
  • Scalable and performant

Example Databricks SQL Dashboard

Concetti di Databricks

Query Filters

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
Concetti di Databricks

Query Parameters

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
Concetti di Databricks

Let's practice!

Concetti di Databricks

Preparing Video For Download...