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-tenanted tables vs. schema-tenanted databases

Multi-tenant modeDescription
Multi-tenanted tables (default)All tenants occupy the same tables, and tenancy is indicated via a column (e.g., organization_id)
Schema-tenanted databaseAll 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 to schema-tenanted database mode, contact Prequel support.