Sundeck's Query Engineering Platform lets you build the right behavior for your specific business needs. You can optimize, govern, secure, experiment with and enhance your Snowflake investment.
Create a Flow using SQL. Connect to a Flow from your tool. No matter the Sundeck edition, create as many flows as you like.
Each time you create a flow, that flow gets a unique host. Use that host when connecting from your favorite tool.
You can create a flow per team, user, use-case, etc. Each flow can be used and modified independently.
Define how you want to manage queries for each flow. Use Hooks and conditions to get things done.
Hooks are the primary tool in Sundeck. They reside inside of flows and let you inspect and intercede to optimize as well as build entirely new interaction paradigms.
Sundeck hooks can be executed before a query is submitted to Snowflake. Change the operation, reroute it or reject it.
Need to do extra operations post-query? Use Post-hooks to do cleanup, update consumption accounting and/or shutdown your warehouse.
Hooks not only let you inspect each query, they also let you intercede. You no longer have to wait for a new feature to solve your use case.
Hooks are executed when queries match a set of configured conditions. Target implicit and explicit properties of each query to customize your Snowflake behavior.
SQL is more than text. Understand context and grammar, and target queries based on this. Identify cartesian joins, and count distinct with ease.
Using open-source QTag, tag and identify query workloads. Know which tool, tool user, workbook, graph and artifact triggered each operation.
Use properties like user, role, target warehouse and query text along with complex boolean logic to target the specific patterns you care about.
Just like Snowflake, Sundeck is SQL-first. That means every feature is available via SQL and we provide a number of powerful tools to understand and control SQL.
Everything in Sundeck can be configured using SQL. DDL for Sundeck objects works just like in Snowflake.
With Sundeck's syntax-aware QLike, inspecting and finding patterns is easier than ever.
Sundeck allows you to introduce new syntax. Create macros for common patterns, enhance as you see fit.
In a few quick steps, you can start using Sundeck to enhance your Snowflake environment. Get more productive today!