[DBT] Add Query comments for better debugging [Tip-3]
Author(s): Karthikeyan Siva Baskaran Originally published on Towards AI. Software Engineering Customize the query comment in each query that triggered from dbt Using query_comment in dbt, we can customize the comments to inject into each query that gets triggered from dbt. For …
[DBT] Set Snowflake Query Tag for each DBT model [Tip-2]
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 …
[DBT] Override Default Schema with Custom Schema name [Tip-1]
Author(s): Karthikeyan Siva Baskaran Originally published on Towards AI. Software Engineering Problem By default, DBT creates a model under the schema which is the combination of target_schema and custom_schema. But, there are scenarios where you want to create the schema using custom_schema …