PipedreamHQ / PipedreamHQ/pipedream
[APP] Snowflake app enhancement - Set Context on each Snowflake app step
- Dominant language
- JavaScript
- Stars
- 11.7k
- Forks
- 5.8k
- Avg merge
- 3d 10h
- Merged PRs (30d)
- 102
Description
**Name of app / service**
Snowflake
We need the ability to set the context on each step that uses the Snowflake app so that we can make use of Node.js steps, rather than being forced to either use Python code or hand-code context references in queries. Specifically, in the configuration for the step, we should be able to select the warehouse, role, database, and schema for the step to use. This will allow a number of benefits, including (but not limited to):
- using a different sized warehouse for a particular query (e.g. if most of the queries only need an XS warehouse, but we need to switch to a 2XL warehouse for one query)
- not having to provide the database and schema for every object referenced in a query (e.g. query joins 3 tables in db1.sch1 to two tables in db2.sch2; if the context set up in the connection is for db1.sch2, then we have to provide the db and schema name for all tables in db2.sch2 and at least the schema for tables in db1; if we can select the database in the config for the step, we can reduce the amount of context we have to provide within the query)
- not having to run queries as multi-step anonymous blocks that include context-setting queries, which prevents it from returning detailed results on the query being run (e.g. BEGIN / USE WAREHOUSE 2XL / INSERT QUERY / END will just return 'anonymous block' while if we can set the context to the 2XL warehouse in the step config, then we can just run INSERT QUERY, and the return will actually report the number of records inserted)
**Link to developer documentation**
docs.snowflake.com
**Is lack of support preventing you from building workflows, or do you have a workaround?**
We are forced to use anonymous blocks and/or Python code to accomplish these sorts of things.
**Are there specific actions, or triggers, you'd like to see for this app? Please let us know here or use the Action and Trigger issue templates to open requests for each!**
I will open other tickets for other enhancements to this app.
Contributor guide
Assessment
This issue has not been assessed yet.