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

Airbyte

Is there an option for normalized tables to be created as normal tables in Snowflake? Right now Airbyte is creating them as transient tables and we're not able to clone them. We use cloning to separate our dev and prod environments in the data development life-cycle. <@U01M89RSAJ3>

&gt; *By default, all Snowflake tables created by dbt are `transient`.*
from: <https://docs.getdbt.com/reference/resource-configs/snowflake-configs>

Are you using DBT?

if you run DBT on your own, you could easily change that in dbt projects settings, in airbyte this is not configurable outside of the default yet

is there somewhere i can see the scripts that airbyte uses to normalize the tables? i could easily run those on my own and change the behavior.

<https://docs.airbyte.io/tutorials/connecting-el-with-t-using-dbt>

thanks <@U01BV1SDQMA> will dig into this a bit with <@U01M89RSAJ3>

I hope this solves it for you, lmk if you need more help!