Snowflake

[pipedream-component-development]

App

Snowflake
docs.snowflake.com

[dxkaufman]

I requested this, assuming it was going to ask me for details since I told it I am interested in changes to an existing integration...

What I'm after is a way to change the active warehouse for a given Snowflake integration, either as a 'use warehouse' step or when selecting the particular app for a given node.js step.

Some other things I'd like to see:

• ability to access the Snowflake connection from Python so I don't have to write code to set it up
• ability to see and edit the main connection configuration (so I can change the default warehouse picked for the connection, for example)
• the prepared statement toggle should either be much easier to get to (i.e. in the view when you're typing in a query) or the integration should be smart enough to know which commands (e.g. not USE WAREHOUSE or TRUNCATE TABLE or various others) do not support prepared statements.
• I think for the Snowflake app to be effective, we really need to be able to set the warehouse and other context information on a per-step basis OR at least be able to change it in a step and have the changes stick in following workflow steps (until changed again).

I'll try to come back and read the contribution guidelines later and split these into separate requests.