There is no dropdown with databases list

[silentsokolov]

This is the same issue as #62 In the Tableau version 2023.3, with any combination of drivers and settings, the dropdown list is missing

---

Tableau Desktop v2023.3.x (and WebView on Server v2023.3.x) ClickHouse v23.8.2.7 clickhouse-tableau-connector-jdbc v0.2.6 Clickhouse JDBC driver: 0.6.0 / 0.5.0 / 0.4.6 / 0.3.2-patch8 / 0.3.2-patch11 Settings: databaseTerm=schema, databaseTerm=catalog, database=default (and spec)

[yurifal]

Do simply adding the databaseTerm=schema to the Custom Connection Parameters on the Advanced tab work for you?

It does work for me (and other users as well): https://github.com/ClickHouse/clickhouse-tableau-connector-jdbc/issues/62#issuecomment-1848958680

[yurifal]

setting the databaseTerm=catalog or specifying the database=<some_name> doesn't work.

[silentsokolov]

any combination of drivers and settings

yes, I tried databaseTerm=schema, databaseTerm=catalog w + w/o database=default, database=<some>

[yurifal]

could you please share the Advanced tab screenshot of your connection dialog?

[yurifal]

for a positive test, please try connecting to this instance:

github.demo.trial.altinity.cloud (8443 demo:demo)

[silentsokolov]

On screen

WebView on Server v2023.3.x ClickHouse v23.8.2.7 clickhouse-tableau-connector-jdbc v0.2.6 Clickhouse JDBC driver: 0.4.6

w/o database=<some> - nothing change

[silentsokolov]

On screen

WebView on Server v2023.3.x ClickHouse ???? (github.demo.trial.altinity.cloud) + SSL clickhouse-tableau-connector-jdbc v0.2.6 Clickhouse JDBC driver: 0.4.6

And yes, it's works

[yurifal]

Their version:

`SELECT version();

version() | ----------+ 23.10.5.20| `

[yurifal]

please DO NOT add database=default to the Connection Parameters

[silentsokolov]

please DO NOT add database=default to the Connection Parameters

w/o database=<some> - nothing change )))

[yurifal]

There's something with the settings of your CH instance, i guess. Could you please ask your CH DBA if any changes made to the configs regarding the metadata queries (catalog/schema/table)?

[yurifal]

Are you able to connect from yet another SQL client using JDBC (DBeaver etc)? Could you try connecting from DBeaver using the databaseTerm=schema set in the Driver Properties?

[silentsokolov]

Finally, problem is an option enable_http_compression, we must force disable it.

BTW it's non-obvious since there is no any error

Thx