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:
| Field | Value |
|---|---|
| Database type | TimescaleDB |
| Port | 5432, PostgreSQL's default, or the port your service shows. |
| Database name | The 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 intimescaledb_informationandtimescaledb_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_informationorjobs. See System Tables.