databricks-sql-python
databricks-sql-python copied to clipboard
databricks
Databricks SQL Connector for Python
When querying NULL or INTERVAL columns from a Databricks SQL warehouse, the connector `Cursor().description` [property](https://github.com/databricks/databricks-sql-python/blob/main/src/databricks/sql/client.py#L1011) reports the type code of the columns as a `'string'`. If I understand things correctly,...
Hello, We are trying to use the databricks sql connector behind an https proxy but this is failing with this error: WARNING:urllib3.connectionpool:Retrying (DatabricksRetryPolicy(total=25, connect=None, read=None, redirect=None, status=None)) after connection broken...
From a remote client, I need to write a script that connects to my SQL Warehouse using a workspace level service principal and creates an SQLAlchemy engine.. which I can...
When you call `fetchmany_arrow(batchsize)` and specify a batch size, you get a table that has multiple record batches. In my experience, the record batches are much smaller than the batch...
I am trying to save a pandas dataframe to a table which contains columns of type list of strings (array). I am doing it using df.to_sql() using sqlalchemy engine. It...
Recently started having issues with the fetchall() method. This exact code was working fine last week, but now this same query statement is throwing the errors seen below. ``` def...
On older versions of the connector (version 2.5.2) and connecting to a cluster where unity catalog is not enabled, it would give us the first failure message. However, after updating...
I would like to be able to use this library with the latest `pandas` version. Currently `pandas` is pinned to `
Has anyone else attempted to use this package in an AWS lambda function, only to find that this package and its dependencies result in a deployment package larger than the...
**Note for reviewers**: Please review this _after_ reviewing #325. ## Description This pull request adds documentation for the forthcoming `execute_async()` feature. It describes the interface and gives some usage examples.
