Hubert-Dudek
Databricks MVP

"I'm trying to connect to Databricks from my IDE (PyCharm) and then run delta table queries from there."

If you are going to deploy later your code to databricks the only solutions which I see is to use databricks-connect or just make development environment in cloud and work there (and use repos for pull requests to production).

If your code will not be deployed to databricks and you want just to query table from somewhere else you can use just JDBC/ODBC connector. If you want to make cluster and different administrator operations you can install databricks-cli and than extend it inside your code something like below example:

from databricks_cli.sdk import ApiClient

from databricks_cli.sdk import service

host = "your_host"

token = "your_token"

client = ApiClient(host=host, token=token)

workspace = service.WorkspaceService(client)


My blog: https://databrickster.medium.com/

View solution in original post