Hi dbt gurus,
My goal is to create a single final_table in dbt by combining data from two different source models. I tried giving both models the same alias to insert into the final_table, but this caused the models to fail. I also tried using a UNION statement to combine them, but the business requirement is to avoid using a UNION. Is there another way in dbt to insert data from multiple source models into one final table without using a UNION?
thanks