metabase-clickhouse-driver icon indicating copy to clipboard operation
metabase-clickhouse-driver copied to clipboard

Published 20 hours ago • verified publisher icon ClickHouse

Only show tables and schema for database given in connection settings

Open nilaymk opened this issue 3 years ago • 1 comments

Scenario :

  • My clickhouse instance has 2 databases my_lovely_db and my_horrid_db
  • While creating a new database connection via "Admin settings", I have provided a value in "Database" field (e.g. my_lovely_db)
  • When I try to admin (e.g. update Data Model) or query (e.g create Questions), it shows both databases as schemas even though I have specified my_lovely_db in connection.

Expected:

  • it should only show the my_lovely_db schema
  • i.e. When a database is provided in the connection string, it should only show that as a schema for that connection.

nilaymk avatar Aug 23 '22 12:08 nilaymk

Thanks @nilaymk for the report. The discovery of the schemas is a fragile point, and the concepts "schema", "catalog" or "table" are not used consistently in MetaBase and the ClickHouse JDBC driver. We will have to work around this issue.

enqueue avatar Aug 24 '22 05:08 enqueue

This is now fixed. See here: https://github.com/ClickHouse/metabase-clickhouse-driver/issues/121

nilaymk avatar Mar 09 '23 11:03 nilaymk