TimescaleDB

TimescaleDB is its own database type in QueryDesk. It is a PostgreSQL extension, so everything that works on PostgreSQL works on TimescaleDB, including data protection, peer reviews and the JSON structure action. QueryDesk is tested against TimescaleDB 2.31 on PostgreSQL 17.

Connect a database

Add the database as in Connect a database, with these values:

FieldValue
Database typeTimescaleDB
Port5432, PostgreSQL's default, or the port your service shows.
Database nameThe database to query, for example tsdb on Timescale Cloud.

Timescale Cloud

A service's connection info gives a postgres:// connection string. Choose TimescaleDB as the database type first, then paste the string under Update with connection string on the database's settings page and click Apply. The database keeps the TimescaleDB type, sslmode=require turns on Encryption, and other query keys become connection parameters, as on PostgreSQL.

Click Test Connection under the credential to check the connection.

What works differently

  • Hypertables sync once. The schema sync reads each hypertable as one table and skips TimescaleDB's own schemas: the chunks in _timescaledb_internal, the catalogs in _timescaledb_catalog, and the views in timescaledb_information and timescaledb_experimental. A policy's rules for a hypertable cover every chunk, and with a policy assigned, a query that names a chunk directly is refused.
  • TimescaleDB's views are system tables. To let a policy's queries read them, add the schema or a view's name under Allowed system tables, for example timescaledb_information or jobs. See System Tables.

Was this page helpful?