Pre-hooks

Pre-hooks are fired before the query is submitted to Snowflake. Pre-hooks can be combined in a Sundeck flow to produce a particular set of outcomes. To see more details about hooks, review the hooks overview.

The following built-in system hooks are currently available in Sundeck:

Auto Routing
Daily Limits
Lookup Routing
Reject
Replace Tables
Rewrite
Route
SQL
Template Engine (Experimental)
Text Fragment Aliases
Usability Helpers
User Defined
Workload Routing

Hook configuration in Sundeck DDL uses Snowflake’s variant literal syntax. This syntax is similar to JSON with the following main differences:
Keys are single quoted (JSON uses double quoting).
String literal values are single quoted ' or dollar-dollar $$ quoted. Sundeck recommends using dollar-dollar quoting to make complex strings easier to build.