In our example , the Timeseries table with the name environmental_data has the following attributes:
"stats": Stats regarding the Timeseries table: "table_size", "index_size", "toast_size", and "total_size". All values of stats are provided in bytes.
"dimensions": The dimension name is "city" and the data type of the corresponding dimension column is "varchar".
"measurements": The measurement column names are "temperature", "ozone", and "relative_humidity", and the data types of the corresponding dimensions are "real".
"defaults": Dictionary containing templates with default dimension value for the measurement "temperature" is set to Gdańsk.
"retention": The retention is set to 3 weeks ("retention": "3M").
"chunk": The chunk length is set to 1 week ("chunk": "1W").
Our request creates the following Timeseries table:
_timestamp
city
temperature
ozone
relative_humidity
If the Timeseries table were to be filled with updated values of Entries of a Ledger, an example of how they would be displayed would be:
list of strings, value is "bigint", "bool", "boolean", "character varying", "date", "double precision", "geography", "geometry", "int", "integer", "interval", "json", "jsonb", "numeric", "real", "smallint", "text", "time", "timestamp", "timestamptz", "varchar", or "uuid".
Data types of the corresponding measurement columns.
defaults
dictionary
Dictionary containing templates for "measurement" (to determine the name of the measurement column to store the Entry value) and "dimensions" (to determine the value for each of the dimensions). Provided default templates are used if no default templates are defined in the "timeseries" property of a Ledger's Entry. The templates follow the Python string str.format() convention (see Format String Syntax(opens new window)).
Attribute
Type
Description
measurement
string
Template that determines the name of the measurement column to store the Entry value. Provided default template is used if no default template is defined in the "timeseries" property of a Ledger's Entry. The template follows the Python string str.format() convention (see Format String Syntax(opens new window)).
dimensions
dictionary
Template that determines the value for each of the dimensions. Provided default template is used if no default template is defined in the "timeseries" property of a Ledger's Entry. The template follows the Python string str.format() convention (see Format String Syntax(opens new window)).
timestamp
string
Template that determines the value of the timestamp.