Superset Connection with OpenTSDB

[kalyan540]

@dosu Can someone Suggest workaround regarding connecting OpenTSDB to superset ?

[dosubot[bot]]

To connect OpenTSDB to Superset, follow these steps:

1. Install the Required Database Driver: Ensure you have the necessary Python DB-API driver and SQLAlchemy dialect for OpenTSDB. You may need to search for a suitable SQLAlchemy dialect and driver for OpenTSDB.

2. Add the Driver to Superset: If you are using Docker, add the driver to the requirements-local.txt file in the docker directory. For example:

   echo "opentsdb-driver-package" >> ./docker/requirements-local.txt

3. Rebuild and Restart Superset: If you are using a customized Docker image, rebuild your local image with the new driver:

   docker compose build --force-rm
   docker compose up

4. Configure the Connection in Superset: Go to the Superset web UI, navigate to Settings -> Data: Database Connections, and click the +DATABASE button. Enter the connection string for OpenTSDB.

Since OpenTSDB is not explicitly mentioned in the documentation, you may need to refer to the OpenTSDB documentation or community resources to find the exact connection string format and driver package. If you encounter any issues, check the Docker logs or test the connection string directly in a Python environment within the Superset container ^[1].

To continue talking to Dosu, mention @dosu.