Skip to main content

TIMESCALE.INSERT

star This is a Streamsheets 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

NameDescription
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.

Examples

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

For more examples see our timescale tutorial.