Our organization is investing big time on the dbt Semantic Layer. The piece we could not find much documentation on was how to test the metrics in the dbt Semantic layer. The major questions in my mind are -
- How do you test the metrics?
- How to you automate the tests for metrics?
Right now the only way I can think of to test the metrics is - exporting the metrics to the data warehouse and validate values in the exported table by running values against the base tables.