DBT: Reading data from two different select statements

Viewed 21

I am new to dbt and working on a QA implementation for the ETL process. It requires every day,

  • reading the counts from the source tables based on the ETL logic and
  • same counts from the destination table.

The counts from source and destination are supposed to go to the same QA audit table and in the same row for the given day.

Could I use two different models inserted into the same row for a few columns based on the date key?

0 Answers
Related