What is Databricks SQL?
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.
Databricks SQL is not supported in Azure China regions.
Fully managed SQL warehouses in the cloud
SQL queries run on fully managed SQL warehouses sized according to query latency and number of concurrent users. To help you get started quickly, every workspace comes pre-configured with a small starter SQL warehouse. Learn more.
Dashboards for sharing insights
Dashboards let you combine visualizations and text to share insights drawn from your queries. Learn more.
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. Learn more.
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 warehouses, queries, and data.
- Enterprise-grade SLAs.
For details, see Data access overview.
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.
Submit and view feedback for