Skip to main content

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

info

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

Syntax

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

Arguments

NameDescription
StreamStream to use for querying. The database name is configured in the affiliated Connector.
TableNameName of the table.
SelectJSONA SelectJSON to query your data to export.
FilenameName the File.

Return Value

TRUE, if successful.

Examples

FunctionResultComment
=TIMESCALE.EXPORT(, "Table1", JSON(A1:B2), "Export1")TRUEExports data from "Table1" to the file "Export1". The data to export is specified in A1:B2

For more examples see our timescale tutorial.