Hi folks What happens when the destination does not support a particular data type from the source? E.g. Snowflake lacks support for PostgreSQL user-defined types. How can one migrate such data?

Mostly of the cases the data is convert to string. https://docs.airbyte.io/integrations/sources/postgres shows all data types support from the source Postgres. The resulting type is the Airbyte data type.