Visual Studio Code, PyCharm and similar desktop editors are IDEs. Databricks Connect, or the Databricks extension for Visual Studio Code, lets code written in them execute and be debugged on Azure Databricks.
Also called integrated development environment.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains IDE in context, with comparison tables and the common traps.
Terms in this definition
- VS Code
The code editor from Microsoft. Together with the .NET SDK and the SQL Server (mssql) and SQL Database Projects extensions, it can build, check and publish SDK-style database projects for warehouses.
- Databricks Connect
Lets Spark code written in an IDE, a notebook server or an application run on remote Azure Databricks compute. Built on Spark Connect, the library can't be installed where PySpark is already installed locally.
- Databricks
Analytics platform built on Apache Spark where data is processed in notebooks; Unity Catalog is the governance model it recommends.
- EXECUTE
Allows calling a function or loading a registered model in Unity Catalog, and seeing its definition.
USE CATALOGandUSE SCHEMAare needed too.
Related terms
- Lakeflow Pipelines Editor
Develop Lakeflow pipelines in the workspace with this IDE: it edits several files at once and adds an asset browser, a live graph, data previews and an issues panel, and you can run a single file or table on its own.