For anyone who has used Snowflake a lot, they've noticed that there are several constructs that cannot be directly referenced in a query. Examples include SHOW commands and DDL statements. Sundeck automatically allows the use of backticks to automatically expand any subquery, including those not normally allowed above. Sidenote: this is also a fun way to ensure a query is executed in a certain sequence to help the optimizer!
Want to run Python in Snowflake without a bunch of scafollding? Sundeck can allow you to submit Python code directly to Snowflake. Execute your own Python script composing data from any environment that knows how to submit Snowflake queries.
Security in Snowflake is powerful. It's also recursive. That recursion means that it is often more difficult to get the data you actually want when trying to understand object permissions. Rather than trying to remember a bunch of complex recursive queries, just use Sundeck's SHOW RECURSIVE GRANTS command.
Want to override Snowflake behavior for a specific query without having to make it into multiple operations? This can easily be accomplished using Sundeck's custom hooks for directives. Reroute to a different warehouse, set a timeout, bypass the Sundeck flows, etc, all using sugared directives.
In a few quick steps, you can start using Sundeck to enhance your Snowflake environment.
Get more productive today!
