What is Databricks SQL (Preview)?

Databricks SQL allows you to run quick ad-hoc SQL queries on your data lake. Queries support multiple visualization types to help you explore your query results from different perspectives.

Fully managed SQL endpoints in the cloud

SQL queries run on fully managed SQL endpoints sized according to query latency and number of concurrent users.

Dashboards for sharing insights

Dashboards let you combine visualizations and text to share insights drawn from your queries.

Alerts help you monitor and integrate

Alerts notify you when a field returned by a query meets a threshold. Use alerts to monitor your business or integrate them with tools to start workflows such as user onboarding or support tickets.

Enterprise security

Databricks SQL provides enterprise-grade Azure security, including Azure Active Directory integration, role-based controls, and SLAs that protect your data and your business.

  • Integration with Azure Active Directory enables you to run complete Azure-based solutions using Databricks SQL.
  • Role based access enables fine-grained user permissions for alerts, dashboards, SQL endpoints, queries, and data.
  • Enterprise-grade SLAs.

Important

Azure Databricks is a Microsoft Azure first-party service that is deployed on the Global Azure Public Cloud infrastructure. All communications between components of the service, including between the public IPs in the control plane and the customer data plane, remain within the Microsoft Azure network backbone. See also Microsoft global network.

Integration with Azure services

Databricks SQL integrates with Azure databases and stores: Synapse Analytics, Cosmos DB, Data Lake Store, and Blob storage.

Integration with Power BI

Through rich integration with Power BI, Databricks SQL allows you to discover and share your impactful insights quickly and easily. You can use other BI tools as well, such as Tableau Software.

Next steps