- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-29-2021 04:13 AM
"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/