snowflake incremental models with virtual columns failures

I was recently working on converting a table managed outside of dbt to our dbt project. It is an incremental model, and the table in question contains a couple of virtual fields. While testing my dbt incremental model implementation, I was getting odd “ambiguous column” errors. It turned out the reason for the errors had to do with the virtual columns. Our resolution was to add pre-hooks to drop the virtual columns and post hooks to re-add them, and then the model ran fine. Just thought I’d share, especially since its kind of an obscure issue and took a while to track down.

2 Likes

Thanks for taking the time to share this solution, @nadelman ! :clap:

1 Like