Databricks SQL Demo

Overview

• Scalable, fully managed interactive query engine for BI and SQL workloads
• Outperforms leading data warehouses on price-performance basis
• Best-in-class open connectors for BI/reporting tools like Power BI, Looker, Tableau
• Built-in SQL IDE
• Enables self-serve analytics on Databricks Lakehouse Platform

Setting Up

Inviting Users

• Add new users by email
• Sync with Azure Active Directory, AWS IAM, Okta, or other cloud identity providers
• Provide login access to Lakehouse and assign data permissions

Configuring Data Access

• Enable serverless SQL for instant compute with minimal management
• Input data lake storage credentials for access

Data Management

Data Explorer

• Discover datasets, browse schemas, and view sample data
• View table schema, sample data, and data file locations
• Manage permissions for groups or individual users

Permissions Management

• Grant/revoke access using standard SQL grant statements
• Can automate permission management via built-in SQL query editor or sync with Azure Active Directory

SQL Endpoints

• View & monitor health of endpoints
• Create new endpoints easily with t-shirt sizing for capacity adjustment
• Multi-cluster load balancing for high concurrency workloads
• Photon engine for faster, efficient SQL execution

Integration with Tableau

• Copy SQL endpoint credentials
• Create a personal access token for authentication
• Connect to Databricks SQL endpoint in Tableau
• Run interactive queries and build visualizations in Tableau

Monitoring and Auditability

• Monitor endpoint status and load
• View query history for auditability, lineage, data governance
• Detailed query execution statistics available

Data Analyst Perspective

• Starter SQL endpoint with sample datasets, queries, dashboards
• New SQL query editor supports persistent tabs
• Convert query results into visualizations and dashboards
• Personal query history accessible for review