databricks-sql-python
databricks-sql-python copied to clipboard
Databricks SQL Connector for Python
Hello, I am currently working on a FastAPI application which calls Databricks using `databricks-sql-connector`, however the code appears to slow down massively on the engine creation stage. I've narrowed the...
This may be a dumb question, but it's not exactly clear how to do query parameters specifically with sqlalchemy 2 from `docs/parameters.md`. For the old sqlalchemy dialect on databricks-sql-connector 2.7.0,...
**main.py content** ```python from dotenv import load_dotenv, dotenv_values load_dotenv() from databricks.sdk.core import Config, oauth_service_principal from databricks import sql import os server_hostname = os.getenv("DATABRICKS_HOST") def credential_provider(): config = Config( host =...
Writing large amounts of data to disk, only for `databricks-sql-connector` to then read it back in from disk, is incredibly inefficient. It would be much more efficient to be able...
Hi, I believe there is an issue specific to macOS users, as I encountered problems getting the workspace example to work correctly on my Mac. I found a similar issue...
implements https://github.com/databricks/databricks-sql-python/issues/427
[PECO-1926] ## Description To handle the flow of result when pyarrow is not present. This setup is particularly used for users who want to handle small quantities of data ##...
I initially reported this issue against dbt-databricks but was asked by a collaborator to file it here. So basically, when running dbt request against a serverless sql warehouse, we get...
[PECO-1803] ### Related Links databricks_sqlalchemy split is present in this PR - https://github.com/databricks/databricks-sqlalchemy/pull/1 ## Description databricks-sql-python library is split so that package size can be reduced for the end user...
Hello, My team and I have been using the `databricks-sql-python` library for a year now. It works great for the majority of our use cases, most of which involve linear...