clickhouse-tableau-connector-jdbc icon indicating copy to clipboard operation
clickhouse-tableau-connector-jdbc copied to clipboard

Published 20 hours ago • verified publisher icon ClickHouse

Clickhouse default_database user parameter not working

Open vlauzeckas opened this issue 1 year ago • 2 comments

default_database parameter not working with Tableau connector: create database test_db; CREATE TABLE test_db.test_table ( id Int64 ) 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

vlauzeckas avatar Aug 11 '23 11:08 vlauzeckas