To update the normalization logic for an existing connection without directly modifying the dbt project, you can follow these steps to customize Airbyte normalization using a custom dbt run: 1. Enable Airbyte’s Normalization for the Connection and Run the First Sync: - This will generate the initial dbt project with the default normalization logic. 2. Find the Generated dbt Project Folder in the Running Container: - Locate the dbt project that was generated during the first sync. This is typically found within the Airbyte container. 3. Export the Project to a Separate Repository: - Copy the generated dbt project to a separate repository where you can make custom modifications. 4. Tweak Parameters for the Project: - Modify the dbt project as needed to change the schema or any other normalization logic. 5. Disable Airbyte’s Normalization and Enable Custom Normalization Using the New Repository: - In the Airbyte UI, disable the default normalization for the connection. - Configure the connection to use the custom dbt project from your repository. Here is a summary of the steps in a list format: - Enable Airbyte’s normalization for the connection and run the first sync. - Find the generated dbt project folder in the running container. - Export the project to a separate repository. - Tweak parameters for the project. - Disable Airbyte’s normalization and enable custom normalization using the new repo. For more detailed instructions, you can refer to the relevant documentation: - [Transformations with dbt](https://docs.airbyte.io/operator-guides/transformation-and-normalization/transformations-with-dbt) - [Transformations with Airbyte](https://docs.airbyte.io/operator-guides/transformation-and-normalization/transformations-with-airbyte) If you need further assistance, you can also check the [Airbyte forum post](https://discuss.airbyte.io/t/1295) where similar topics are discussed.