Skip to content

v3.0.0

Compare
Choose a tag to compare
@susodapop susodapop released this 17 Nov 18:15
· 44 commits to main since this release
c3fdc2f

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)