ClickHouse / clickhouse-tableau-connector-jdbc

Tableau connector to ClickHouse using JDBC driver
Apache License 2.0
57 stars 9 forks source link

Clickhouse default_database user parameter not working #57

Open vlauzeckas opened 1 year ago

vlauzeckas commented 1 year ago

default_database parameter not working with Tableau connector: create database test_db; CREATE TABLE test_db.test_table (idInt64 ) ENGINE= MergeTree ORDER BY (id) SETTINGS index_granularity = 8192; CREATE USER test_user IDENTIFIED WITH sha256_password BY 'qwerty' DEFAULT DATABASE 'test_db' ; grant all on test_db.test_table to test_user;

but in tableau if you try to execute custom query: select * from test_table

connector still try to look into default database:

image

bun4uk commented 11 months ago

We use these parameters to specify database CleanShot 2023-10-12 at 17 19 32@2x

yurifal commented 11 months ago

Try putting this in the URL Parameters instead.