Multi-tenant filtering
Configuring your data tenancy mode
Prequel is purpose-built to handle syncing data from (or to) multi-tenanted data sources (and destinations). There are two types of multi-tenant database configurations supported by Prequel.
Multi-tenant mode | Description |
---|---|
Multi-tenanted tables (default ) | All tenants occupy the same tables, and tenancy is indicated via a column (e.g., organization_id ) |
Schema-tenanted database | All tenants occupy their own schema, and tenancy is indicated by the schema. |
Toggling your data tenancy mode
By default, every Prequel account is provisioned in
multi-tenanted tables
mode. To switch your account toschema-tenanted database
mode, contact Prequel support.
Updated 10 months ago