Snowflake pool sometimes persists a temporary table in one session then attempts to access it in another session

[christopherswenson]

There does not seem to be any system in place to make sure that, for a single Malloy compile, the Snowflake connection only uses one session. Because of this, when compiling a Malloy model, the Snowflake connection might persist a query result using one session, then attempt to access that saved result in a different session, which fails.

This is an example of such a failure

This seems to be relevant code

This is an example of a test that might exhibit this behavior