TimescaleDB

TimescaleDB is the open-source relational database for time-series and analytics to build powerful data-intensive applications. TimescaleDB is a PostgreSQL extension, and you can use the standard PostgreSQL connector library, psycopg2, to connect to the database.

If you’re using docker compose, psycopg2 comes out of the box with Superset.

TimescaleDB sample connection parameters:

• User Name: User
• Password: Password
• Database Host:
  • For Localhost: localhost or 127.0.0.1
  • For On Prem: IP address or Host name
  • For Timescale Cloud service: Host name
  • For Managed Service for TimescaleDB service: Host name
• Database Name: Database Name
• Port: default 5432 or Port number of the service

The connection string looks like:

postgresql://{username}:{password}@{host}:{port}/{database name}

You can require SSL by adding ?sslmode=require at the end (e.g. in case you use Timescale Cloud):

postgresql://{username}:{password}@{host}:{port}/{database name}?sslmode=require

Learn more about TimescaleDB!