Creating an analytics application

Introduction to Databricks SQL

Kevin Barlow

Data Manager

What is an analytics application?

Analytics Application Diagram

Introduction to Databricks SQL

Filters and parameters

Filters

  • Creates a sub-selection of the resulting rows based on the specified value or criteria
  • Functions the same as a WHERE clause in a SQL query
    • Text-based, numerical, date ranges, dropdowns

Parameters

  • Arbitrary text values that can be injected into a SQL query
  • Often can be used as a filter
  • Also able to inject other text values
    • Dynamically add fields to query
    • Change the behavior of a function
Introduction to Databricks SQL

Dashboards in Databricks SQL

  • Collection of visualizations from multiple queries and tables
  • Allows for a more dynamic and user-friendly experience for understanding data
    • Leverage existing queries / visualizations
    • Create new queries and visualizations ad hoc
    • Bring in advanced logic with AI / LLMs
  • Shareable through a URL

Example Dashboard

Introduction to Databricks SQL

Partner Connect

BI Tool Integration

  • Leverage an extensive network of partner technologies with your lakehouse architecture
  • Directly connect your favorite BI tool
    • Scalability and performance of compute with Databricks
    • User-friendly and powerful BI capabilities with Power BI, Tableau, etc.
  • Keep users with the tools they are familiar with
Introduction to Databricks SQL

Let's practice!

Introduction to Databricks SQL

Preparing Video For Download...