Hi all! When generating the report, I use the `ed...
# community-support
a
Hi all! When generating the report, I use the
edr report -d 7
command, but the report results contain data for
14 days
, as specified in
training_period
. The question is, can the number of
days-back
be less than
training_period
? This is important for me, because I have
time_bucket = 1 hour
and in the current situation my report is too big due to which the data in the report is not shown at all, instead I just get
No test results
n
Hey @Anna Vasileva 👋🏼 I am not sure I understand what you mean. On the test results page, you will see tests that were run at least once in the past 7 days (as you configured) - you will see only the last invocation of the test in the past 7 days. On
Test Execution History
page, you can see the run history of the past 7 days per test. On
Model Duration
page, you can see all the runs from the last 7 days for each model. The graph you see for a test on the
Results
page, for the relevant tests, in the graph you can see the result of each time_bucket (including the training period). Each graph on this page is a single run of the test. You should not get
No test results
in this case. Did you run
dbt test
in the past 7 days?
a
Hello! Apparently I misunderstood the meaning of the “days-back” flag. I would like to limit the display of results on the "Results" page, since currently they are displayed for the entire training period and this cannot be changed. My HTML file weighs about 1 MB and because of this the file does not open correctly and I only see the inscription "No test results". If I limit the display in the report, for example using a selector, then the file size is reduced and I see all the results correctly.
n
Filtering out data points from the test results graph is not supported. Filtering out some of the data points will make it hard to understand why the test is failing/passing. I don’t think the report size is the issue, it should work anyway. Also, 1 MB is pretty much a small report (my report is 6 MB). Did you run step 3 before running
dbt build
or
dbt test
? Can you please check if you see records in
dbt_run_results
and
elemetary_test_results
from the last 7 days? Also, please make sure you have records in the
dbt_models
and
dbt_tests
tables.
a
Oh, sorry, I mistyped, size 1GB. I add hourly tests for my sources, which are updated once an hour, while specifying the seasonality "hour of day". Yes, all tables exist and they are filled with data.
👍🏼 1
n
Regarding
dbt_run_results
and
elemetary_test_results
tables, what is the max value in the
generated_at
column?
a
I can't check right now, but this is today's date.
And a strange thing I discovered. I am generating a report locally. After this, it opens correctly in the Safari browser, but when I open it in Google, I see an empty report with the inscription
No test results
This text misled me, but it turns out that the report is generated correctly
n
When you open the report on Safari it is working, but the same report (same file) on Google Chrome shows you
No test results
?
a
Yes
Same file
n
Can you share the report with me in a private message?
âś… 1