Skip to content

Helper Queries

Helper queries are a way to define reusable SQL queries that can be used in multiple places in the SBT workflow. They are defined in a .sql file in the helpers directory of the project. Helper queries can use the SeekRunContext object to access sources and other models.

Current use cases for helper queries across the Insight Cloud platform

  • Used to define the freshness timestamp of an app
  • Used to define the valid options for a parameter in a model. This query is used to populate a dropdown in the variant parameter management UI.