Skip to main content
Version: Streamsheets 2.4


star This is a Streamsheets Enterprise feature.

Performs a SELECT query on your timescale database.


As of right now, the timescale functions work with the internal timescaledb. Leave the Stream parameter empty and the connection is automatically set up. We are working on allowing further timescale connections.


=TIMESCALE.SELECT(Stream, SelectJSON [, Target, XValue,])


StreamStream to use for querying. The database name is configured in the affiliated Connector.
SelectJSONDefines a query using a JSON cell range, which contains all clauses to build the SELECT query.
TargetOptional. INBOX(), OUTBOX("MsgID") or a cell range where the result will be placed. Make sure the cell range is big enough or not everything is displayed. You don´t need a target area , if you only want to display charts. You can directly reference the cell with the query. (make sure you Xvalue parameter is set right)
XValueOptional. Name of the value which should be used for the x-axis if result is visualized by a chart. Defaults to "time".

Return Value

TRUE, if successful.


=TIMESCALE.SELECT(, JSON(A1:B2), D1:F20)TRUEAssuming passed JSON looks like { select: '*', from: 'measures' } this will return all values currently stored in measurement "measures" and writes them to cell range D1:F20.

For more examples see our timescale tutorial.