Issue with Transformation Operations for Airtable to PostgreSQL connection

Slack Knowledge Base Q&A Connector Development
, , , ,
1

Summary

Transformation operations are not supported for the Airtable to PostgreSQL connection. User is seeking guidance on mapping and writing data, as well as using dbt for this connection.


Question

Hi team,
I need to create a connection from Airtable to PosgtreSql. I set up the source and destination. But in the transformation section, it warns that Normalization and Transformation operations are not supported for this connection.
Why is happening, How can I map and write my data from Airtable to PostgreSQL? How can I use dbt for this connection?
Thank you


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["airtable", "postgresql", "transformation-operations", "mapping", "dbt"]
2

we’re sunsetting normalization - this functionality is now built directly into the connector (see <https://docs.airbyte.com/using-airbyte/core-concepts/typing-deduping|DV2 docs>) and enabled by default.

Custom dbt transformations are also being sunset - if you’re on cloud, we have a dbt cloud integration; otherwise you’ll need to use your own orchestrator to trigger dbt after running a sync.

3

Thank you for explaining