TIMESCALE.EXPORT

star This is a Streamsheets Premium feature.

Performs an EXPORT query on your Timescale database. This query works exactly like the queries from TIMESCALE.SELECT, but exports the result into a file. This file can be accessed in the side menu of your App under “App Files”. Click here for a more detailed tutorial on timemescaledb functions. .. note:

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

Syntax

=TIMESCALE.EXPORT(Stream, TableName, SelectJSON, Filename, [Compres, Delimiter])

Arguments

Name

Description

Stream

Stream to use for querying. The database name is configured in the affiliated Connector.

TableName

Name of the table.

SelectJSON

A SelectJSON to query your data to export.

Filename

Name the File.

Return Value

TRUE, if successful.

Examples

Function

Result

Comment

=TIMESCALE.EXPORT(“Producer”, “Table1”, JSON(A1:B2), “Export1”)

TRUE

Exports data from “Table1” to the file “Export1”. The data to export is specified in A1:B2