Version:

TimescaleDB

TimescaleDB is an open-source relational database for time-series and analytics, built on PostgreSQL.

Installation

Required packages: psycopg2

Connection String

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

Default port: 5432

Connection Examples

Timescale Cloud (SSL required)

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

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Notes

Uses the PostgreSQL driver. psycopg2 comes bundled with Superset.

Resources

Help improve this documentation by editing the engine spec: