databricks-sql-python
databricks-sql-python copied to clipboard
databricks
Databricks SQL Connector for Python
Current Databricks Sql Alchemy uses describe command/show schema/table to get metadata Can we use system tables to get metadata
Hi, i have created a small python-script to fetch data from the sql-endpoint in azure databricks. The queried view has 2126641 rows. As you can see, CloudFetch serves batches as...
Testcase 1 ``` Python 3.10.15 (main, Sep 7 2024, 18:35:33) [GCC 9.4.0] on linux Type "help", "copyright", "credits" or "license" for more information. >>> from databricks import sql >>> sql.__version__...
Hi Team, We have observed that the cursor doesn't respond/raise exceptions when a query is cancelled in the backend it just hangs (keeps on running) I don't see any solutions...
Hello, I have trouble using parameters with `databricks-sql-python`, using a Databricks cluster with Unity Catalog with Runtime 15.4. This will fail: ```python from databricks import sql as databricks_sql with databricks_sql.connect(...
I've connected to our databricks workspace with a `sa.Engine`, specifying the database/catalog as `my-catalog`: ```python >>> engine Engine(databricks://token:***@mycompany-test.cloud.databricks.com:443/my-catalog) ``` In this catalog I have a `test` schema which has a...
## Description This PR implements the pattern described [here](https://github.com/databricks/databricks-sql-python/issues/458#issuecomment-2442887279) to emit a log message if the user _passes_ a None value for their `access_token`, since this is likely not intentional....
I have two tables I want to query from, the fully qualified names are `foo_catalog.foo_schema.foo` and `bar_catalog.bar_schema.bar`. I can specify a schema and a tablename in the table definition but...
Version 2.9.6 Repro: ``` from sqlalchemy import create_engine, MetaData, Table, select, column # Assuming you have a working database connection string engine = create_engine('...'). # make sure to specify the...
