Version: Streamsheets 2.5

TIMESCALE.INSERT

This is a premium feature.

Performs a STORE query on your Timescale database.

info

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.

Syntax

=TIMESCALE.INSERT(Stream, TableName, ValuesJSON, [TableSchemaJSON])

Arguments

Name	Description
Stream	Stream to use for querying. The database name is configured in the affiliated Connector.
TableName	Name of the table to store values to. Note: its fully qualified name will be written to target range, if provided.
ValuesJSON	A JSON with key/value pairs to store.
TableSchemaJSON (optional)	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 specified schema is setup. Supported schema values can be NUMERIC, TEXT, TIMESTAMP,, TIMESTAMPTZ, DATE, INTEGER etc. See here for detailed explanation.

Return

TRUE, if successful.

Examples

Formula	Result	Comment
`=TIMESCALE.INSERT(, D5, JSON(C6:D7),JSON(C2:D3))`	TRUE	Creates a table with the given schema and stores the values in that table.
`=TIMESCALE.INSERT(, "measures", { v1: "hello" })`	TRUE	Stores "hello" under v1 in the "measures" table.

For more examples see our timescale tutorial.