Sunday, January 14, 2024
Similar to how we enable users to leverage the meta keys / tags they've configured in their dbt project, users can now filter and slice by any custom top-level query comment/tag keys. Once you've specified which keys you want to access in the settings, you'll be able to access them as filter/slicing options throughout SELECT.
Consider the following example dbt model, queries
:
Once this model is run and the dbt project has our dbt-snowflake-query-tags package installed, the SQL will look like this:
It's possible for users to add additional top level keys to the query comment metadata. A custom top level key would be anything not included by default in the comment above. The internal_job_name
key (with a value of hourly_run
) in the comment below would be an example of this:
Up next.Previous Changelog Entries.
Connect your Snowflake account and instantly understand your savings potential.