databricks/databricks-sql-python v3.0.0

on GitHub

You can now pip install databricks-sql-connector==3.0.0.

This release:

• Removes support for Python 3.7
• Adds support for native parameterized SQL queries. Requires DBR 14.2 and above. See here for more information.
• Includes our completely rewritten SQLAlchemy dialect:
  • Adds support for SQLAlchemy >= 2.0 and drops support for SQLAlchemy 1.x
  • Full e2e test coverage of all supported features
  • Detailed usage notes available here
  • Adds support for:
    • New types: TIME, TIMESTAMP, TIMESTAMP_NTZ, TINYINT
    • Numeric type scale and precision, like Numeric(10,2)
    • Reading and writing PrimaryKeyConstraint and ForeignKeyConstraint
    • Reading and writing composite keys
    • Reading and writing from views
    • Writing Identity to tables (i.e. autoincrementing primary keys)
    • LIMIT and OFFSET for paging through results
    • Caching metadata calls
• Enables cloud fetch by default. To disable, set use_cloud_fetch=False when building databricks.sql.client.
• Add integration tests for Databricks UC Volumes ingestion queries
• Retries:
  • Add _retry_max_redirects config
  • Set _enable_v3_retries=True and warn if users override it.
• Security: Bumps minimum pyarrow version to 14.0.1 (CVE-2023-47248)