Target the Right Queries
Sundeck hooks can be configured to fire under only certain conditions. Relevant tables, shape of SQL, the user executing the query and the targeted warehouse are all available. You can also use advanced features like QLike and QTag
Target by User or Role
Target queries by the User that is submitting them. Use this to implement fine grained control around quotas or manage exceptions for power users.
Find Queries by Table(s) Referenced
Syntax- and context-aware identification of tables. Identify queries by the specific set of tables, schemas and/or databases they refer to or (don't).
QTag: Target Based on Structured Comments
Sundeck has Open Source QTag built-in. This automatically makes any structured comment available as a first-class property for query targeting. Many tools already automatically add QTags and you're free to add your own QTags.
QLike: Search for Queries by their DNA
Use QLike to target queries by their general SQL shape. QLike is a powerful Sundeck technology that lets users identify queries based on the nature of the syntax. Looking for 3-way inequality joins? Want queries that use at least two count distincts? Searching for queries that apply a filter on column y? QLike can help you achieve all of those things and more.
Complex Boolean Logic & Null Handling
Build up boolean logic that supports comparison of values, and, or and not expressions along with support for intelligent null handling.
Target By Warehouse
Identify queries destined for a particular warehouse. Reroute to another warehouse if you want to save money or improve overall performance.