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-tenanted tables vs. schema-tenanted databases
| 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 tablesmode. To switch your account toschema-tenanted databasemode, contact Prequel support.
Updated about 1 year ago