![]() Now that you have the driver and connector in the appropriate folders on your machine, let's see how to define a data source in Tableau that connects to the TPCD database in ClickHouse. Configure a ClickHouse data source in Tableau and start building data visualizations!Ĭonfigure a ClickHouse data source in Tableau .Windows: C:\Program Files\Tableau\Drivers.Store the JDBC driver in the following folder (based on your OS, if the folder doesn't exist you can create it):.Make sure you download the clickhouse-jdbc-x.x.x-shaded.jar JAR file. Windows: C:\Users\Documents\My Tableau Repository\Connectorsįollow clickhouse-tableau-connector-jdbc instructions to download the compatible version of ClickHouse JDBC driver.macOS: ~/Documents/My Tableau Repository/Connectors. ![]() Store the TACO connector in the following folder (based on your OS): If you are using self-managed ClickHouse, the connection details are set by your ClickHouse administrator.ĭownload the latest version of the ANALYTIKA PLUS clickhouse-tableau-connector-jdbc TACO connector. Select the service that you will connect to and click Connect:Ĭhoose HTTPS, and the details are available in an example curl command. The details for your ClickHouse Cloud service are available in the ClickHouse Cloud console. Use the username appropriate for your use case. The USERNAME and PASSWORD: out of the box, the username is default. ![]() The DATABASE NAME: out of the box, there is a database named default, use the name of the database that you want to connect to. ![]() The HOST and PORT: typically, the port is 8443 when using TLS or 8123 when not using TLS. To connect to ClickHouse with HTTP(S) you need this information: This requires a special JDBC driver to be downloaded and saved into a specific location where Tableau can find it. Tableau can use ClickHouse databases and tables as a data source.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |