Flows

Sundeck allows you to modify queries that are submitted to Snowflake. Sundeck emulates Snowflake and is accessible from most tools by simply changing the host the tool is connecting to.

To use the Sundeck to modify queries, you create one or more flows. A flow contains a list of hooks that are executed. You can create an arbitrary number of flows and each flow can be used independently. Each flow has a unique hostname for access purposes. In the UI (or via SUNDECK DDL) you can see the hostname for each flow.

Flows can be used just like Snowflake accounts. Anyone who has access to a Snowflake account can also utilize any existing flows attached to that Snowflake account. In the simplest case, Sundeck just forwards operations down to Snowflake to execute.

In addition to simple forwarding, one or more Hooks can be added to a flow. Hooks can be configured to fire either before the query is submitted to Snowflake (which are called pre-hooks), or after the query has executed (called post-hooks). Pre-hooks allow you to change the behavior of the query, and post-hooks allow you to conditionally perform follow-on tasks after query execution.
You can add a number of hooks to a flow and each hook defines a set of conditions which determine whether it should be executed on a particular query.

To get started, take a look at hooks to understand more about what types of operations can be done.