Tseesecake is a lightweight proxy for time-series query engines, supporting multiple database engines and storage providers, with a SQL dialect dedicated to time series
When you want to define a temporal slicer you should use the semantic BUCKET columnName BY.
The accepted values for the bucketization by truncation should be seconds, minutes, hours, days, months, years. The current value of the timestamp will be truncated (round down) to the level provided in parameter of the expression.
BUCKET Instant BY MINUTE
Singular/Plural both should be supported.
Translation should be a slicer 'date_trunc' in DuckDB
When you want to define a temporal slicer you should use the semantic
BUCKET columnName BY
.The accepted values for the bucketization by truncation should be seconds, minutes, hours, days, months, years. The current value of the timestamp will be truncated (round down) to the level provided in parameter of the expression.
Singular/Plural both should be supported.
Translation should be a slicer 'date_trunc' in DuckDB