Skip to main content
Version: Streamsheets 2.4


star This is a Streamsheets Enterprise feature.

Performs a STORE 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.INSERT(Stream, TableName, ValuesJSON [,TableSchemaJSON])


StreamStream to use for querying. The database name is configured in the affiliated Connector.
TableNameName of the table to store values to. Note: its fully qualified name will be written to target range, if provided.
ValuesJSONA JSON with key/value pairs to store.
TableSchemaJSONOptional. The timescale enforces the usage of a schema. If the used table is not already created, enter a JSON Range with a schema. Now for every new table the specifed schema is setup. Supported schema values can be NUMERIC, TEXT, TIMESTAMP,, TIMESTAMPTZ, DATE, INTEGER etc. See here for detailed explanation.

Return Value

TRUE, if successful.


=TIMESCALE.INSERT(, "measures", { v1: "hello" })TRUEStores "hello" under v1 in the "measures" table.

For more examples see our timescale tutorial.