shemik7
09/12/2025, 2:07 PMkapa.ai
09/12/2025, 2:07 PMkapa.ai
09/12/2025, 2:07 PMvars: elementary: test_sample_row_count: 5 # or higher Elementary stores these samples in the warehouse (test_result_rows / test_results_samples) and not raw data by default. [[Security & privacy](https://docs.elementary-data.com/cloud/general/security-and-privacy#what-information-does-elementary-collect%3F); [Athena thread](https://slack.com/archives/C02CTC89LAX/p1741861180336069)] 2) With dbt 1.8+, you must allow Elementary to override test materializations so samples are captured. Add: flags: require_explicit_package_overrides_for_builtin_materializations: false This fixes empty test_result_rows on newer dbt versions. [[dbt 1.8 flag](https://slack.com/archives/C02CTC89LAX/p1734111312018389)] Notes: - You can increase sample size via test_sample_row_count; by default it’s small (e.g., 5). [[Sample size var](https://slack.com/archives/C02CTC89LAX/p1682955847416029); [store samples table](https://slack.com/archives/C02CTC89LAX/p1696900519445739)] - Only samples are stored, not all failed rows. [[Subset stored](https://slack.com/archives/C02CTC89LAX/p1709061533176029)] - If you customized tests or rely on temp tables, copying the “result query” may not work for some anomaly tests due to temp tables; this is a known issue in older versions. [[Invalid temp table query](https://github.com/elementary-data/elementary/issues/1483)] After applying the flags/vars, rerun tests and edr report; the “Test results” section should show samples again pulled from test_result_rows. [[Sample rows feature](https://slack.com/archives/C02CTC89LAX/p1704319265407929)]shemik7
09/12/2025, 2:35 PMkapa.ai
09/12/2025, 2:35 PMkapa.ai
09/12/2025, 2:35 PM