Hi All,
dbt introduce a new testing frame work (check the above link) we are also trying to implement same in our project. But this approach have issue like its working fine with simple models
But in case of complex models this approach is throwing error because its not able to call the the source macro using schema.yml.
We have one data model where we are perfoming union all with two regions data , so when Im doing testing testing just with one regions it working fine. Below i have provided the code for one union node.
SELECT *
FROM (
SELECT *
FROM (
SELECT ID AS JSDHSJ, DSAHD AS ADHJA, SDBJSAD AS JHRJAHF, SDJK AS JDSFJ, SFJSA AS FDJFKL, AdhfM AS URD, AE AS CHAN, ZS, TIMSTP,SYS
FROM (
SELECT ID AS JSDHSJ, DSAHD AS ADHJA, SDBJSAD AS JHRJAHF, SDJK AS JDSFJ, SFJSA AS FDJFKL, AdhfM AS URD, AE AS CHAN, ZS, TIMSTP,SYS
FROM db.schema_AS.ABC AS MAST
LEFT JOIN
(SELECT PREFIX,ZS
FROM db.SAP.MAP) SYS
ON MAST.ZS = SYS.ZS))
)
Similar we have another block of code only difference is that we taking the data from schema_EU schema instead of schema_AS and we club both the data set using union all. Its means when code size is get increases dbt fails to test the models.
Error Message
Compilation Error in unit_test logic_testing_0003 (models\virtualized\bom_v_make_bom_schema.yml)
Unit_Test ‘unit_test.ops_dbt_wrk_to_wrk.v_make_bom__my_models’ (models\virtualized\make_bill
ofmaterials_v_make_bom_schema.yml) depends on a source named ‘Schema_AS.MAST’ which was not found
For your information we have verfied that Schema_AS.MAST table is already avilable in source.yml.
Then also we are getting the above error.
Pls help us on this issue.
Thanks in advance