Clickhouse-connect

Latest version: v0.8.16

Safety actively analyzes 723650 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

Page 10 of 20

0.6.7

Bug Fixes
- Fixed an issue for older versions of ClickHouse where the server would send an initial block of 0 rows for larger queries.
This would break some queries with LowCardinality columns. Closes https://github.com/ClickHouse/clickhouse-connect/issues/221
- Fixed the`compression` alias for the `compress` client setting in SQLAlchemy/Superset DSN urls.

Improvements
- Upgraded to Cython 3.0.0 final release!
- Reversed the internal variable names of keys and indexes for low cardinality columns to be consistent with the ClickHouse server nomenclature.

0.6.6

Bug Fix
- Inserting into an Enum column from a Pandas DataFrame with integer values only inserted 0 values. This is fixed.
https://github.com/ClickHouse/clickhouse-connect/issues/219

0.6.5

Bug Fixes
- The Client min_version method now ignores unrecognized "text" elements. This could cause issues for unofficial
ClickHouse releases. Thanks to [Diego Nieto](https://github.com/lesandie) for the fix!
- In most cases insert query is now sent as part of the POST body instead of as a query parameter. This fixes
https://github.com/ClickHouse/clickhouse-connect/issues/213. Note that this does not happen for direct file inserts
using the `driver.tools` module, since these rely on an unmodified buffered input stream to efficiently upload files.
In that case the actual insert query will still be passed as a query parameter.
- All datetime objects returned from a query will now be timezone aware. This fixes https://github.com/ClickHouse/clickhouse-connect/issues/210.
There remains one exception to this -- if the calculated timezone and the local timezone are both UTC, then naive timezones
will be used to improve performance in such "all UTC" environments.
- Inserting Python dictionaries into a ClickHouse "named" Tuple column now works correctly. Fixes https://github.com/ClickHouse/clickhouse-connect/issues/215.
Note that using dictionaries for inserts will be noticeably slower than inserting the equivalent Python tuple value
(with elements in the correct order)

Improvements
- Client error messages used to be cut off at 240 characters to avoid creating huge log files. This value is now
configurable using the `common.max_error_size` setting. Use `0` for this setting to get the full ClickHouse
error message. In addition, the default has been changed to `1024` to capture more SQL errors without needing to
modify the global setting value. Thanks to [Ramlah Aziz](https://github.com/RamlahAziz) for the update!
- All Client insert methods now return a simple QuerySummary object, which includes properties `written_rows`,
`written_bytes`, and `query_id` calculated from ClickHouse HTTP response headers. A QuerySummary object is also
returned from the Client `command` method if the command does not return other data. Closes https://github.com/ClickHouse/clickhouse-connect/issues/216
- Version determination no longer indirectly depends on the setuptools `pkg_resources` package. This also
avoids some indirect dependency problems. Thanks to [cwegener](https://github.com/cwegener) for the PR!

0.6.4

Bug Fixes
- Quote database name when retrieving tables via SQLAlchemy. Fixes the Superset issue https://github.com/apache/superset/issues/24372
for recent versions of Superset using clickhouse-connect
- Don't rely on the ClickHouse currentDatabase() function to set an explicit database parameter. This should not change functionality
when no database is specified in Client creation since ClickHouse will use the user's default database in that situation regardless.
Fixes https://github.com/ClickHouse/clickhouse-connect/issues/207

0.6.3

Bug Fix
- Inserts into decimal columns first convert the source value to a Python Decimal to work around floating point
rounding issues. Fixes https://github.com/ClickHouse/clickhouse-connect/issues/203
- DateTime64 values were broken for dates before 01-01-1970. This is fixed. https://github.com/ClickHouse/clickhouse-connect/issues/204

0.6.2

Improvements
- Cython version upgraded to 3.0.0b3
- Inserts for string columns are now C optimized (approximately 2x faster)

Bug Fix
- Very long running queries could break because ClickHouse returned too many progress headers. Thanks to
[Ivan](https://github.com/istrebitel-1) for the fix

Page 10 of 20

© 2025 Safety CLI Cybersecurity Inc. All Rights Reserved.