No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.

[arekgotfryd]

Describe the bug
When I run make deploy against snowfalke environment I'm getting following error:
[_ENVELOPE_ARR] ERROR: No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.

To Reproduce
Steps to reproduce the behavior:

1. Use the cloud 'snowflake'
2. Run the query 'make deploy'
3. See error
   [_ENVELOPE_ARR] ERROR: No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.

Expected behavior
I would expect additional SF_WAREHOUSE environment variable in .env file.

Screenshots
If applicable, add screenshots to help explain your problem.

Additional context
I'm happy to provide pull request with required changes in run-query.js and run-script.js files.

[vdelacruzb]

Hi @arekgotfryd,
Thanks for creating this issue and letting us know. We were expecting users to have a default warehouse set up but you have a good point and having an optional env variable SF_WAREHOUSE seems very convenient.
We have created a ticket for this and will tackle it as soon as possible.

In the meantime, could you set a default warehouse in your Snowflake account? or just adding the warehouse option directly inside your run-query.js and run-script.js?

Kind regards

[arekgotfryd]

Hi @vdelacruzb,
thanks for response. Are you willing to accept pull request for this?
If the team wants to cover this in it's own capacity I'm fine.

[vdelacruzb]

Hi @arekgotfryd,
Sure, feel free to create a pull request with this change.
We are always happy to receive contributions.

If not, we will cover it but it might take a bit.