Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

Hello! How can I set `table_ab2.sql`  ?
I want that my Airbyte pipeline changes the date type from BigInt to Int,
I access to the model and the sql, and modified but I want that it would be the default for the next normalization without using dbt and sql tool, only changing the sql.

I'm using S3 source to Redshift.

Hi <@U01MMSDJGC9> I was able to get the `table_ab2.sql` and I modified, but the next iteration ignore it. How can I fix it or if it is possible?

You need to copy the dbt project, change locally and run as custom transformation.

Thanks <@U01MMSDJGC9> I follow the documentation for private repo and now it's working.