I created a new connection with a postgres destination. The transformation is configured for incremental dedupe+history. The first sync is showing an error during normalization via dbt:

relation "airbyte._airbyte_raw_prefix_streamname" does not exist

obviously that table does not exist, its the first sync, what could be the reason for that error? there is no previous error in the logs that would explain this error.

The error you're encountering,

relation "airbyte._airbyte_raw_prefix_streamname" does not exist

, during the first sync with incremental dedupe+history mode in a Postgres destination, suggests that the raw table

_airbyte_raw_prefix_streamname

was not created successfully before the normalization step was attempted. Here are a few potential reasons and steps to troubleshoot this issue: 1. Check the Initial Sync Process: Ensure that the initial sync process is correctly creating the raw tables. You can verify this by checking the list of tables in your Postgres destination after the sync attempt. Use the following command in your Postgres shell:

sql    \dt;

This should list all the tables in your destination, including any

_airbyte_raw_

tables. 2. Review the Logs for Raw Table Creation: Look through the logs to confirm that the raw tables are being created without errors. The absence of

_airbyte_raw_

tables indicates that there might be an issue earlier in the sync process that prevents their creation. 3. Configuration Issues: Ensure that your destination configuration is correct. Misconfigurations can sometimes lead to issues where tables are not created as expected. Double-check your destination settings in Airbyte. 4. Permissions: Verify that the user account used for the Postgres destination has the necessary permissions to create tables. Lack of permissions can prevent the creation of required tables. 5. Airbyte Version and Connector Compatibility: Ensure that you are using compatible versions of Airbyte and the Postgres connector. Sometimes, version mismatches can lead to unexpected errors. 6. Incremental Deduped + History Mode: This mode requires specific columns like

_airbyte_unique_key

to be present. Ensure that your source data and configuration align with the requirements for this mode. For more details, you can refer to the [Airbyte tutorial on incremental deduped + history synchronization](https://airbyte.com/tutorials/incremental-data-synchronization#step-7). If you have verified all the above steps and the issue persists, it might be helpful to provide more detailed logs or open a support ticket with Airbyte for further assistance. For more information, you can refer to the relevant knowledge sources: - [Airbyte Forum Post on Incremental Deduped History Normalization Error](https://discuss.airbyte.io/t/2033) - [Airbyte Tutorial on Incremental Data Synchronization](https://airbyte.com/tutorials/incremental-data-synchronization#step-7) If you need further assistance, feel free to ask!