Generated result query in report contains an invalid table

[cshlin]

Describe the bug
When trying to copy the result query to view the failed rows, I get a query that contains an invalid tmp table

To Reproduce
Steps to reproduce the behavior:

1. On the generated EDR html report, click on Results
2. Expand a test failure, and in the Result section, click the Copy button beside the Result Query
3. Receive the following query (see the FROM clause on line 50 in the attached .txt file)

edr.txt

Expected behavior
A query that provides me with the failed rows

Screenshots

Environment (please complete the following information):

• edr Version: 0.14.1
• dbt package Version: 0.14.1

Additional context
Add any other context about the problem here.

[haritamar]

Hi @cshlin !
Thanks for posting this issue and sorry for the delayed response.
You're right - there is a temp table here that is available during the test run, but is not available afterwards. We need to save instead a query that will not require this temp table.

Any chance you'd like to contribute a fix to this?
I'd be happy to provide guidance with a possible approach to fix this.

[cshlin]

Absolutely, point me in the right direction and I can implement CharlesOn May 19, 2024, at 15:45, Itamar Hartstein ***@***.***> wrote: Hi @cshlin ! Thanks for posting this issue and sorry for the delayed response. You're right - there is a temp table here that is available during the test run, but is not available afterwards. We need to save instead a query that will not require this temp table. Any chance you'd like to contribute a fix to this? I'd be happy to provide guidance with a possible approach to fix this. —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you were mentioned.Message ID: ***@***.***>