Hi Everyone,
I have a dbt model which is reading from many sources. I want to mock these sources using CSV files as input data in seeds and then the model will run. After the model ran successfully, I want to aggregate the data and compare it with the expected output which is also a CSV file stored in seeds. I want these tests to happen in the CI/CD so there will be no changes in the command such as dbt seeds, dbt tests, dbt run … How can i achieve this.
I have tried dbt-datamocktool. In that, I’m not able to aggregate the final result and then compare.
Any help will be appreciated.