Schema Exclusion Rules for Postgres Fan-In
Regular expressions can exclude specific Postgres schemas from automatic fan-in, with a preview of matching schemas before replication starts.
When fanning in data from Postgres, things can get tricky if two schemas on the same server contain tables with the same name - but different formats. For example, tenant-specific schemas should be unified, while other schemas with overlapping table names should stay separate. Without guardrails, this creates collisions and inconsistent data downstream.
You can now use regular expressions to exclude specific schemas from automatic fan-in. To make setup easier, Artie previews which schemas match (and don't match) your rule before replication starts - giving you full visibility and control.
Why this matters:
- Designed for customers managing complex fan-in scenarios
- Prevents incorrect unification of tables that share names but differ in structure
- Reduces downstream data errors and inconsistencies
- Eliminates manual filtering and fragile workarounds
- Provides transparency by previewing schema matches before syncing