Connecting to ClickHouse from Apache Superset™
Apache Superset™ is an open-source modern data exploration and visualization platform. In this example we will show how you can connect to your ClickHouse cluster from Apache Superset™. Before you begin, it is imperative to review the general steps and considerations for connecting to a ClickHouse cluster as outlined in Connecting to a ClickHouse Cluster.
1. Go to your Superset web console and click on the + Database. This will bring up the Connect a database dialog.
2. From SUPPORTED DATABASES dropdown, choose ClickHouse Connect (Superset). If you do not have this option, you may need to install it first in Superset using the following command:
|
1 |
pip install clickhouse-connect |
To learn more about the Python driver for ClickHouse, check out https://github.com/ClickHouse/clickhouse-connect
3. Populate all the details upon gathering necessary information from your cluster’s Connection Info page on Instaclustr Console. Make sure the SSL option is enabled.
4. Once you have correctly input all required details tap CONNECT and then FINISH in the following step.
That’s all! At this point your ClickHouse database should be available for use in Superset.
