<@U088WCP3B4P> Does elementary write the output of...
# ask-elementary-ai
s
@kapa.ai Does elementary write the output of test cases back to snowflake?
k
A message from kapa.ai
Yes, Elementary writes the output of test cases back to Snowflake. When you run dbt tests with the Elementary package installed, the results are stored in tables such as elementary_test_results and test_result_rows within your configured Elementary schema in Snowflake. These tables accumulate test results incrementally from the moment of installation, allowing you to query and analyze test outcomes directly in your data warehouse. Note that only a sample of failing rows is saved in test_result_rows, but you can adjust the sample size if needed. The tables are updated as part of each dbt run and test execution, provided the setup and permissions are correct [FAQ: result samples in the report](https://docs.elementary-data.com/oss/general/faq) [Slack answer about logs and incremental storage](https://slack.com/archives/C02CTC89LAX/p1686507519412139).