Hi,
I am using dbt SQL models and deploy them to Snowflake as views. I am exploring the dbt Python models lately. Can we have a model where some of the parts or tables are taken using the with CTE(dbt SQL models style) and some parts or tables taken using def model()(dbt Python models style).
The reason is there are few transformations on the data that I need to do. So my idea is to ref the data from other data sources and use python to transform the data and create new columns and hence I am looking for a hybrid approach.
Example structure looking for
with cte1 as(
)
with cte2 as(
)
def model():{
}
select * from final;
Thanks for suggestions in advance