- Fixed
LowCardinality(Nullable)
types introspection, where it was incorrectly reported astype/*
(#203)
- Removed forward slash from serialized IPv4/IPv6 columns. NB: IPv4/IPv6 columns are temporarily resolved as
type/TextLike
instead oftype/IPAddress
base type due to an unexpected result in Metabase 0.47 type check. - Removed superfluous CAST calls from generated queries that use Date* columns and/or intervals
- Use HoneySQL2 in the driver
- Metabase 0.47 support
- Connection impersonation support (0.47 feature)
- More correct general database type -> base type mapping
DateTime64
is now correctly mapped to:type/DateTime
database-required
field property is now correctly set totrue
if a field is notNullable
- JDBC driver upgrade (v0.4.1 -> v0.4.6)
- Support DateTime64 by @lucas-tubi (#165)
- Use native
startsWith
/endsWith
instead ofLIKE str%
/LIKE %str
- Fixed temporal bucketing issues (see #155)
- Fixed Nippy error on cached questions (see #147)
- Fixed
sum-where
behavior where previously it could not be applied to Int columns (see #156)
- Hide
.inner
tables of Materialized Views. - Resolve
Map
base type totype/Dictionary
. - Database name can now contain multiple schemas in the UI field (space-separated by default), which tells the driver to scan selected databases. Separator can be set in
metabase.driver.clickhouse/SEPARATOR
. (@veschin)
- Now the driver is able to scan and work with
SimpleAggregateFunction
columns: those were excluded by mistake in 1.0.2.
- Metabase 0.46.x compatibility.
- Added cljc.java-time to dependencies, as it is no longer loaded by Metabase.
- Update JDBC driver to v0.4.1.
- Use new
product_name
additional option instead ofclient_name
- Replace
sql-jdbc.execute/read-column [:clickhouse Types/ARRAY]
withsql-jdbc.execute/read-column-thunk [:clickhouse Types/ARRAY]
to be compatible with Metabase 0.46 breaking changes once it is released.
- Fix
sql-jdbc.execute/read-column-thunk [:clickhouse Types/TIME]
return type.
- Adds a new "Scan all databases" UI toggle (disabled by default), which tells the driver to scan all available databases (excluding
system
andinformation_schema
) instead of only the database it is connected to. - Database input moved below host/port/username/password in the UI.
- Fixed NPE that could be thrown by the driver in case of empty database name input.
- As the underlying JDBC driver version does not support columns with
(Simple)AggregationFunction
type, these columns are now excluded from the table metadata and data browser result sets to prevent sync or data browsing errors.
Formal stable release milestone.
- Added HTTP User-Agent (via clickhouse-jdbc
client_name
setting) with the plugin info according to the language client spec
- Allow to bypass system-wide proxy settings #120
It's the first plugin release from the ClickHouse organization.
From now on, the plugin is distributed under the Apache 2.0 License.
- Using https://github.com/ClickHouse/clickhouse-jdbc
v0.3.2-patch11
NB: there are messages like this in the Metabase logs
2022-12-07 11:20:58,056 WARN internal.ClickHouseConnectionImpl :: [JDBC Compliant Mode] Transaction is not supported. You may change jdbcCompliant to false to throw SQLException instead.
2022-12-07 11:20:58,056 WARN internal.ClickHouseConnectionImpl :: [JDBC Compliant Mode] Transaction [ce0e121a-419a-4414-ac39-30f79eff7afd] (0 queries & 0 savepoints) is committed.
Unfortunately, this is the behaviour of the underlying JDBC driver now.
Please consider raising the log level for com.clickhouse.jdbc.internal.ClickHouseConnectionImpl
to ERROR
.
- Enable additional options for ClickHouse connection
- Compatibility with Metabase 0.44