Composite PostgreSQL types as text
PostgreSQL sources support an opt-in compositeTypesAsText setting, also available in Terraform, that represents composite values as text.
PostgreSQL composite types can be difficult to map into destination schemas when downstream systems do not support the native type.
PostgreSQL sources now support an opt-in compositeTypesAsText setting, also available as composite_types_as_text in Terraform, to represent composite values as text.
Why this matters
- Replicate PostgreSQL tables containing composite types into broader destination sets
- Choose a portable representation without changing the source schema