Make Elementary test tables as temp tables

[Dineshvrma]

Is your feature request related to a problem? Please describe.
Once elementary is set up in a DBT repository for Snowflake as the underlying Data warehouse. After running the tests there are tables getting created in the elementary schema and as long as the number of tests increases, the tables also increase and might blow up space for unwanted tables.

Describe the solution you'd like
These tables can be made temporary and should drop once the session is complete

Additional context

Would you be willing to contribute this feature?
I would like to contribute, But my availability is minimum given the bandwidth is less for me. But would love to check how to contribute for the same

[leilafi]

I'm closing #979 as this feature seems to resolve it. Just wondering if there are any updated on this request?

[elongl]

Hi @Dineshvrma, @leilafi !
From now on Elementary's temporary test tables will automatically be deleted.
This change will be released in the upcoming version.
Thanks a lot for opening the issue.