DB Connection from Apache Superset

Connecting ChistaDATA database from Apache Superset

Apache Superset is an open-source software and a top level project at Apache Software foundation. It is an application for data exploration and data visualization which is designed to handle data at petabyte scale.

Pre-requisites

  • A Running Cluster from ChistaData (any tier/size)
  • Apache Superset installed and running
  • clickhouse-connect python package installed alongside apache superset (pip install clickhouse-connect)

Steps

  1. In Superset home, navigate to Data -> Databases. Select the add new Database button on the top right.

Add Database option in superset Add Database option in superset

  1. The following screen will be displayed

Add Database screen Add Database screen

  1. Go to the ChistaData cluster and note the hostname to connect

Find the hostname Find the hostname

  1. Select the ClickHouse Connect from the supported databases.

DB server details DB server details

  1. Go back to the Superset. Enter the hostname from the previous step. Mention the port as 8443 (https port) and enter the database username and password.

DB server details DB server details

  1. Enable SSL and click Connect

Enable SSL Enable SSL

  1. If the credentials are correct, you will be taken to the next screen. Select Finish if no optional settings are required for now. Finalize the settings Finalize the settings

  2. The new connection should be displayed now in the Databases section.

Successful connection Successful connection

Thats all. You have connected your database to Superset and the data in the database is ready to be Visualized and explored.