Where can I find Airbyte normalization compiled SQL? I'm trying to understand this error better by trying to find this compiled SQL during a Redshift -> Postgres sync:

2023-01-18 03:35:27 normalization > Database Error in model monthly_bank_account_balance_by_workspace_stg (models/generated/airbyte_incremental/accounting_metrics/monthly_bank_account_balance_by_workspace_stg.sql)
2023-01-18 03:35:27 normalization >   cannot delete from table "monthly_bank_account_balance_by_workspace_stg" because it does not have a replica identity and publishes deletes
2023-01-18 03:35:27 normalization >   HINT:  To enable deleting from the table, set REPLICA IDENTITY using ALTER TABLE.
2023-01-18 03:35:27 normalization >   compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/accounting_metrics/monthly_bank_account_balance_by_workspace_stg.sql

Hey I hope this helps https://docs.airbyte.com/operator-guides/transformation-and-normalization/transformations-with-dbt

Let me know if Akilesh's comment helps!

Thanks Akliesh, though unfortunately I can't figure it out. I've SSH'd into both the server and worker, but can't find where this is

models/generated/airbyte_incremental/accounting_metrics/monthly_bank_account_balance_by_workspace_stg.sql

. I've gone as far as running

find / -name "monthly_bank_account_balance_by_workspace_stg.sql"

on both but with no results. We have our Airbyte deployment configured (maybe incorrectly?) to push logs to an S3 bucket, but I can only find the same logs that show up in the webapp UI, not the normalization logs.

Hey @Alvin Khaled you need to execute these two step Validate dbt project settings and Exporting dbt normalization project outside Airbyte (you can create it as shell file and execute it) in you server, once you execute it in the same directory you will find a directory called 'tutorial` then cd into this location

tutorial/normalization-files/normalize/

where you find all models.