Creates stg tables for ZTL, dbt build completed successfully:
Creates preliminary int tables for ZTL, dbt build completed successfully:
Create preliminary SQL queries for the product table. dbt build completed successfully.
** Modifications made to product table and int tables
The primary key for the product table is dtm_id. _intermediate_models.yml was modified to add table expectations that dtm_id or the combination of dtm_id and the joined column ids are unique, avoiding duplicate records. When pivoting the int tables using row_numbers, corrections were made to the queries to ensure that the joining process doesn't create duplicate dtm_id. The product table passed all tests and has dtm_id as its unique identifier.
resolves #925
Creates stg tables for ZTL,
dbt buildcompleted successfully:Creates preliminary int tables for ZTL,
dbt buildcompleted successfully:Create preliminary SQL queries for the product table.
dbt buildcompleted successfully.** Modifications made to product table and int tables The primary key for the product table is
dtm_id._intermediate_models.ymlwas modified to add table expectations thatdtm_idor the combination ofdtm_idand the joined column ids are unique, avoiding duplicate records. When pivoting the int tables usingrow_numbers, corrections were made to the queries to ensure that the joining process doesn't create duplicatedtm_id.The product table passed all tests and hasdtm_idas its unique identifier.