Today, we are excited to announce that users can now run SQL queries on Databricks from within Visual Studio Code via a preview driver for the popular SQLTools extension. This preview release complements the recently launched public preview of the Databricks extension for VS Code, which allows users to sync and run code developed locally on Databricks-managed compute.
Databricks SQL (DBSQL) is a serverless data warehouse built on the Databricks Lakehouse Platform that enables you to run all of your SQL and BI applications at scale with up to 12x better price and performance compared to legacy data warehouses. DBSQL uses open formats and APIs through a unified governance model with your preferred tools. Now you can connect from VS Code to DBSQL as well as to All Purpose clusters, run SQL queries, and view results without leaving the comfort and power of your favorite editor. This is especially useful if you are working on a dbt project on Databricks and need to iterate on SQL queries while building data models.
The demo below shows how to install the extension and run a SQL query on Databricks:
We want to thank Matheus Texiera, the author of the popular SQLTools extension and the open-source contributors who have made this extension successful. We would love for you to try this extension out.