Name: Towards AI Legal Name: Towards AI, Inc. Description: Towards AI is the world's leading artificial intelligence (AI) and technology publication. Read by thought-leaders and decision-makers around the world. Phone Number: +1-650-246-9381 Email: [email protected]
228 Park Avenue South New York, NY 10003 United States
Website: Publisher: https://towardsai.net/#publisher Diversity Policy: https://towardsai.net/about Ethics Policy: https://towardsai.net/about Masthead: https://towardsai.net/about
Name: Towards AI Legal Name: Towards AI, Inc. Description: Towards AI is the world's leading artificial intelligence (AI) and technology publication. Founders: Roberto Iriondo, , Job Title: Co-founder and Advisor Works for: Towards AI, Inc. Follow Roberto: X, LinkedIn, GitHub, Google Scholar, Towards AI Profile, Medium, ML@CMU, FreeCodeCamp, Crunchbase, Bloomberg, Roberto Iriondo, Generative AI Lab, Generative AI Lab Denis Piffaretti, Job Title: Co-founder Works for: Towards AI, Inc. Louie Peters, Job Title: Co-founder Works for: Towards AI, Inc. Louis-François Bouchard, Job Title: Co-founder Works for: Towards AI, Inc. Cover:
Towards AI Cover
Logo:
Towards AI Logo
Areas Served: Worldwide Alternate Name: Towards AI, Inc. Alternate Name: Towards AI Co. Alternate Name: towards ai Alternate Name: towardsai Alternate Name: towards.ai Alternate Name: tai Alternate Name: toward ai Alternate Name: toward.ai Alternate Name: Towards AI, Inc. Alternate Name: towardsai.net Alternate Name: pub.towardsai.net
5 stars – based on 497 reviews

Frequently Used, Contextual References

TODO: Remember to copy unique IDs whenever it needs used. i.e., URL: 304b2e42315e

Resources

Unlock the full potential of AI with Building LLMs for Productionβ€”our 470+ page guide to mastering LLMs with practical projects and expert insights!

Publication

[DBT] Set Snowflake Query Tag for each DBT model [Tip-2]
Latest   Machine Learning

[DBT] Set Snowflake Query Tag for each DBT model [Tip-2]

Last Updated on July 26, 2023 by Editorial Team

Author(s): Karthikeyan Siva Baskaran

Originally published on Towards AI.

Software Engineering

Query Tag feature in DBT is a database-specific configuration. In this article, let see how to customize it for Snowflake.

Query tags are a Snowflake parameter that can be quite useful later on when searching in the QUERY_HISTORY view.

Default Query Tag can be set in the Profiles.yml

This will be applied to all the queries triggered from DBT to Snowflake.

3 ways to configure query tag

  1. Configure it in dbt_project.yml, the drawback in this approach is we can only add string, can’t execute a macro with the current dbt version. For now, DBT supports only a few lists of contexts in the project YAML file.
Source: https://docs.getdbt.com/reference/resource-configs/snowflake-configs

2. Configure it under each model config, the drawback is repeating the same config in all models, which is not a good practice.

Source: https://docs.getdbt.com/reference/resource-configs/snowflake-configs

Solution

3. Override the default query tag macro and customize it based on the requirement.

Before each model, the Snowflake session-level query tags will be updated. Once the model run is completed, it will be automatically reset to default query tag which is set in profiles.yml

alter session set query_tag = β€˜dbt_model_name’

DBT log output when log to console is enabled for the demo,

Snowflake History queries below,

The above same code is also maintained under this ever-growing git repository.

GitHub – karthikeyan-sivabaskaran/dbt-tips-and-tricks-series: This repo will keep growing to demo…

You can't perform that action at this time. You signed in with another tab or window. You signed out in another tab or…

github.com

I hope this article helped you to customise the query tag. If you like this blog, please share it with your teammates, friends, and clap U+1F44F in the range of 1 to 50 in Medium. You can clap up to 50 times per post.

Photo by Stillness InMotion on Unsplash

Happy Overriding!

This article is part of DBT Tips and Tricks Series. Previous articles like below:

[DBT] Override Default Schema with Custom Schema name [Tip-1]

This article is part of the DBT Tips and Tricks Series

medium.com

Join thousands of data leaders on the AI newsletter. Join over 80,000 subscribers and keep up to date with the latest developments in AI. From research to projects and ideas. If you are building an AI startup, an AI-related product, or a service, we invite you to consider becoming aΒ sponsor.

Published via Towards AI

Feedback ↓