Hi, this is the first time I have used Clickhouse DB, I tried to publish my dashboard (using Clickhouse) to Tableau Cloud but it failed. Said Publish failure. Tableau doesn't recognize the data source type 'clickhouse_odbc'

@Raghu Byra​ 

Hi, recently Tableau Cloud has made available the connection using the odbc connection with the Altinity connector. Steps c and d are optional, if you want to refresh extracts.

a. Download the taco connector:

https://exchange.tableau.com/es-ES/products/604

Copy the taco connector to C:\Users\[Windows User]\My Tableau Repository\Connectors\ and C:\Users\[Windows User]\My Tableau Bridge Repository\Connectors\

b. Install the ODBC Driver:

https://github.com/ClickHouse/clickhouse-odbc/releases

unzip, and intall the msi package.

c. Configure Tableau Bridge Pool: Install Tableau Bridge, Sign into Tableau Bridge. Then, create a bridge pool, add the bridge client to the bridge pool, and add your server to the allowlist:

https://help.tableau.com/current/online/en-us/to_enable_bridge_live_connections.htm

d. Test: Connect to clickhouse, publish the datasource to Tableau Cloud, refresh the extract.

If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

Regards,

Diego Martinez

Tableau Visionary and Forums Ambassador