TIMESCALE.INSERT
Premium
Performs a STORE query on your Timescale database.
info
As of right now, the timescale functions work with the internal timescaledb. Leave the Connection parameter empty and the connection is automatically set up. We are working on allowing further timescale connections.
Syntax
=TIMESCALE.INSERT(Connection, TableName, ValuesJSON, [TableSchemaJSON])
Arguments
| Name | Type | Description |
|---|---|---|
| Connection | Connection | Connection to use for querying. Leave this parameter empty. The internal timescaledb is automatically connected. |
| TableName | String | Name of the table to store values to. Note: its fully qualified name will be written to target range, if provided. |
| ValuesJSON | JSON | A JSON with key/value pairs to store. |
| TableSchemaJSON (optional) | JSON | 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
| Type | Description |
|---|---|
| Boolean | TRUE, if successful. |
Examples
| A | B | |
|---|---|---|
| 1 | Schema: | |
| 2 | Cats | NUMERIC |
| 3 | Dogs | NUMERIC |
| 4 | ||
| 5 | Table: | TimescaleDbTable |
| 6 | Cats | 1 |
| 7 | Dogs | 94 |
| Formula | Result | Comment |
|---|---|---|
| TRUE | Creates a table with the given schema and stores the values in that table. |
| TRUE | Stores "hello" under v1 in the "measures" table. |
For more examples see our timescale tutorial.