Connecting to Clickhouse
I was recently speaking with Kat about certified connectors and related status for those connectors – specifically related to Clickhouse, which is listed as a Certified data connector for Sisense.
...
Forum Discussion
Clickhouse supports both MySql and PostgreSql wire protocols. Setting these up on the Clickhouse side allows you to use the MySql or Postgres connectors to connect to Clickhouse. As Sisense can go live to Postgres, you can also go live to Clickhouse using the Postgres connector.
MySQL worked for you? We get an error - "text": "{\"error\":{\"moreInfo\":{\"why\":{\"name\":\"InvalidParametersException\",\"message\":\"InvalidParametersException\",\"errorCode\":8,\"errorMessage\":\"Code: 47. DB::Exception: Missing columns: 'TABLE_COMMENT' while processing query: 'SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, multiIf(TABLE_TYPE = 'BASE TABLE', multiIf((TABLE_SCHEMA = 'mysql') OR (TABLE_SCHEMA = 'performance_schema'), 'SYSTEM TABLE', 'TABLE'), TABLE_TYPE = 'TEMPORARY', 'LOCAL_TEMPORARY', TABLE_TYPE) AS TABLE_TYPE, TABLE_COMMENT AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION FROM (SELECT \",\"wrongParameter\":null,\"dbSourceErrorMessage\":null,\"trace\":null}},\"code\":22002,\"message\":\"Cannot establish connection with provided parameters.\",\"status\":400,\"httpMessage\":\"Bad Request\"}}"
And if we try from postgres we get "ERROR: ClickHouse doesn't support extended query mechanism"
And if I set "preferQueryMode=simple" it then complains that pg_database doesnt exist.
I tried against an the most recent version of Clickhouse and it still fails. Are you doing some magic with the INFORMATION_SCHEMA DB or pg_database tables to get MySQL and PostgreSQL to connect?
