Hey <@U088WCP3B4P>, I'm getting empty reports from...
# ask-elementary-ai
n
Hey @kapa.ai, I'm getting empty reports from project. I have noticed that if I comment out most of my data tests, I get a proper report, but as soon as I add in some more accepted_range or other tests (with no clear pattern I can notice), reports turn back empty. I see there are tests in the elementary_test_results table as well as content in dbt_models and dbt_tests, and I can't see any error in the logs (which I'm attaching). What may be happening?
k
Sorry @Naza, it looks like your question contains files, which I cannot process. Please reformulate your question without including any files.
n
I'm getting empty reports from project. I have noticed that if I comment out most of my data tests, I get a proper report, but as soon as I add in some more accepted_range or other tests (with no clear pattern I can notice), reports turn back empty. I see there are tests in the elementary_test_results table as well as content in dbt_models and dbt_tests, and I can't see any error in the logs (which I'm sending below). What may be happening?
Copy code
2025-07-16 16:10:14 — INFO — Running dbt command --log-format json deps --project-dir /Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /Users/nazareno/workspace/data-etl/code/data_tests
2025-07-16 16:10:15 — DEBUG — Running dbt command --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_latest_invocation", "macro_args": {}} --project-dir /Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /Users/nazareno/workspace/data-etl/code/data_tests
2025-07-16 16:10:18 — DEBUG — Result bytes size for command '['--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_latest_invocation", "macro_args": {}}', '--project-dir', '/Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/Users/nazareno/workspace/data-etl/code/data_tests']' is 2851
2025-07-16 16:10:18 — DEBUG — Running dbt command --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_adapter_type_and_unique_id", "macro_args": {}} --project-dir /Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /Users/nazareno/workspace/data-etl/code/data_tests
2025-07-16 16:10:21 — DEBUG — Result bytes size for command '['--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_adapter_type_and_unique_id", "macro_args": {}}', '--project-dir', '/Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/Users/nazareno/workspace/data-etl/code/data_tests']' is 455
2025-07-16 16:10:21 — INFO — edr (0.19.3) and Elementary's dbt package (0.19.0) are compatible.
2025-07-16 16:10:21 — DEBUG — Running dbt command --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_elementary_database_and_schema", "macro_args": {}} --project-dir /Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /Users/nazareno/workspace/data-etl/code/data_tests
2025-07-16 16:10:23 — DEBUG — Result bytes size for command '['--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_elementary_database_and_schema", "macro_args": {}}', '--project-dir', '/Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/Users/nazareno/workspace/data-etl/code/data_tests']' is 471
2025-07-16 16:10:23 — INFO — Elementary's database and schema: '"pipelinedb.scoring_dbt_elementary"'
2025-07-16 16:10:23 — INFO — Running dbt command --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_test_results", "macro_args": {"days_back": 7, "invocations_per_test": 720, "disable_passed_test_metrics": false}} --project-dir /Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /Users/nazareno/workspace/data-etl/code/data_tests
2025-07-16 16:10:32 — DEBUG — Result bytes size for command '['--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_test_results", "macro_args": {"days_back": 7, "invocations_per_test": 720, "disable_passed_test_metrics": false}}', '--project-dir', '/Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/Users/nazareno/workspace/data-etl/code/data_tests']' is 72547673
2025-07-16 16:10:32 — INFO — Running dbt command --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_source_freshness_results", "macro_args": {"days_back": 7, "invocations_per_test": 720}} --project-dir /Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /Users/nazareno/workspace/data-etl/code/data_tests
2025-07-16 16:10:35 — DEBUG — Result bytes size for command '['--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_source_freshness_results", "macro_args": {"days_back": 7, "invocations_per_test": 720}}', '--project-dir', '/Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/Users/nazareno/workspace/data-etl/code/data_tests']' is 401
2025-07-16 16:10:35 — INFO — Running dbt command --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_seeds", "macro_args": {}} --project-dir /Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /Users/nazareno/workspace/data-etl/code/data_tests
2025-07-16 16:10:38 — DEBUG — Result bytes size for command '['--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_seeds", "macro_args": {}}', '--project-dir', '/Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/Users/nazareno/workspace/data-etl/code/data_tests']' is 1875
2025-07-16 16:10:38 — INFO — Running dbt command --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_snapshots", "macro_args": {}} --project-dir /Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /Users/nazareno/workspace/data-etl/code/data_tests
2025-07-16 16:10:40 — DEBUG — Result bytes size for command '['--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_snapshots", "macro_args": {}}', '--project-dir', '/Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/Users/nazareno/workspace/data-etl/code/data_tests']' is 401
2025-07-16 16:10:40 — INFO — Running dbt command --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_models", "macro_args": {"exclude_elementary": true}} --project-dir /Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /Users/nazareno/workspace/data-etl/code/data_tests
2025-07-16 16:10:43 — DEBUG — Result bytes size for command '['--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_models", "macro_args": {"exclude_elementary": true}}', '--project-dir', '/Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/Users/nazareno/workspace/data-etl/code/data_tests']' is 66541
2025-07-16 16:10:43 — INFO — Running dbt command --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_sources", "macro_args": {}} --project-dir /Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /Users/nazareno/workspace/data-etl/code/data_tests
2025-07-16 16:10:46 — DEBUG — Result bytes size for command '['--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_sources", "macro_args": {}}', '--project-dir', '/Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/Users/nazareno/workspace/data-etl/code/data_tests']' is 25765
2025-07-16 16:10:46 — INFO — Running dbt command --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_exposures", "macro_args": {}} --project-dir /Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /Users/nazareno/workspace/data-etl/code/data_tests
2025-07-16 16:10:49 — DEBUG — Result bytes size for command '['--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_exposures", "macro_args": {}}', '--project-dir', '/Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/Users/nazareno/workspace/data-etl/code/data_tests']' is 401
2025-07-16 16:10:49 — INFO — Running dbt command --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_singular_tests", "macro_args": {}} --project-dir /Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /Users/nazareno/workspace/data-etl/code/data_tests
2025-07-16 16:10:51 — DEBUG — Result bytes size for command '['--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_singular_tests", "macro_args": {}}', '--project-dir', '/Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/Users/nazareno/workspace/data-etl/code/data_tests']' is 401
2025-07-16 16:10:51 — INFO — Running dbt command --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_models_runs", "macro_args": {"days_back": 7, "exclude_elementary": true}} --project-dir /Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /Users/nazareno/workspace/data-etl/code/data_tests
2025-07-16 16:10:56 — DEBUG — Result bytes size for command '['--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_models_runs", "macro_args": {"days_back": 7, "exclude_elementary": true}}', '--project-dir', '/Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/Users/nazareno/workspace/data-etl/code/data_tests']' is 10574731
2025-07-16 16:10:56 — INFO — Running dbt command --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_dbt_models_test_coverage", "macro_args": {}} --project-dir /Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /Users/nazareno/workspace/data-etl/code/data_tests
2025-07-16 16:10:59 — DEBUG — Result bytes size for command '['--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_dbt_models_test_coverage", "macro_args": {}}', '--project-dir', '/Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/Users/nazareno/workspace/data-etl/code/data_tests']' is 3447
2025-07-16 16:10:59 — INFO — Running dbt command --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_tests", "macro_args": {}} --project-dir /Users/nazareno/workspace/data-etl/.venv/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /Users/nazareno/workspace/data-etl/code/data_tests