Data Queries
Data queries select the data that form part of a bucket, using the bucket parameters.
Multiple data queries can be specified for a single bucket definition.
Data queries are used to group data into buckets, so each data query must use every bucket parameter.
Examples
Grouping by list_id
Selecting output columns
When specific columns are selected, only those columns are synchronized to the client.
This is good practice, to ensure the synced data does not unintentionally change when new columns are added to the schema.
Note: An id
column must always be present, and must have a text
type. If the primary key is different, use a column alias and/or transformations to output a text
id column.
Renaming columns
Different names (aliases) may be specified for columns:
Transforming columns
A limited set of operators and functions are available to transform the output value of columns.
Last updated