TimescaleDB

https://www.timescale.com/

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

Feature Score: 34/201

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Extended Time Grains:

FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR

Notes

Uses the PostgreSQL driver. psycopg2 comes bundled with Superset.

Resources

Official Documentation

Help improve this documentation by editing the engine spec:

Edit superset.db_engine_specs.timescaledb.py