Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Sync data from Postgres partitioned tables in legacy Sync Rules using wildcard table name matching.
% for wildcard suffix matching of the table name:
bucket_definitions:
by_user:
# Use wildcard in a parameter query
parameters: SELECT id AS user_id FROM "users_%"
data:
# Use wildcard in a data query
- SELECT * FROM "todos_%" AS todos WHERE user_id = bucket.user_id
_table_suffix column, which you can use to filter rows:
SELECT * FROM "todos_%" AS todos WHERE _table_suffix != 'archived'
publish_via_partition_root on the publication is not supported. The individual partitions must be published.