ClickHouse
Regarding clickhouse connectivity issue with tableau server
Hi Team, This is regarding clickhouse connecting to the tableau server.
Please find below the Step we have followed with respect to the same:
- Installed click house ODBC in windows server
- Connected to clickhouse database from Tableau Desktop and created a report successfully.
- While publishing the Report to Tableau Server from Tableau Desktop We are getting the following error
HTTP status code: 400 Received error: Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 33 (' The table "students" does not exist. Generic ODBC requires additional configuration. The driver and DSN (data source name) must be installed and configured to match the connection. Unable to connect to the server "clickhouse-server" using the driver "ClickHouse ODBC Driver (ANSI)". Check that the server is running and that you have access privileges to the requested database.
This is to inform you that In step 3 We configured clickhouse ODBC in Tableau server(Linux Based). The configuration is as follows: Path : /home/tableau/.odbc.ini [clickhouse] Driver = /opt/clickhouse-odbc-1.1.9-Linux/lib/libclickhouseodbc.so Url = http://default:default@clickhouseip:8123/query?database=default Host = clickhouseip Port = 8123 Path = /query Database = default Username = default Password = default
isql -v clickhouse +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> select 1 +----+ | 1 | +----+ | 1 | +----+ SQLRowCount returns 1 1 rows fetched SQL>
can you please help in troubleshooting the same?
Try to remove database=default from url in odbc.ini if students table not in 'default' database
Do you use the same DSN name in all systems? Regarding your odbc.ini it should be clickhouse.
Yes in both windows & Linux we configured the same name windows: clickhouse Linux : clickhouse
Can you investigate what query executes on clickhouse from tableau in system.query_log table?
If log_queries is not enabled, you can add log_queries=1 to the end of Url in odbc.ini.
Also, you can remove unnecessary fields in odbc.ini:
Host = clickhouseip
Port = 8123
Path = /query
Database = default
Username = default
Password = default
or remove Url and leave them.
I am also facing the same issue, i have created a connection with specific database but i have few joins on physical table and have a logical view , but tableau says the default.table does not exists.
Try using the driver via https://github.com/Altinity/clickhouse-tableau-connector-odbc
