Skip to content

[Bug]: dbt_artifacts not respecting set_query_tag() in snowflake #546

@MazrimT

Description

@MazrimT

Overview

When running the queries against snowflake to upload the logs dbt_artifacts does not set a query_tag in snowflake.
This is done in dbt with set_query_tag() macro (built in to dbt-snowflake).

How to reproduce

Run anything against snowflake and look at snowflakes query history, the inserts does not have query_tags

Expected behaviour

dbt_artifacts should respect the set_query_tag() macro in dbt-snowflake and use either the built in or the user-specified custom override one.

Screenshots

Image

Environment

Results of running dbt --version:

Core:
  - installed: 1.10.13
  - latest:    1.11.7  - Update available!

  Your version of dbt-core is out of date!
  You can find instructions for upgrading here:
  https://docs.getdbt.com/docs/installation

Plugins:
  - snowflake: 1.11.1 - Update available!

  At least one plugin is out of date with dbt-core.
  You can find instructions for upgrading here:
  https://docs.getdbt.com/docs/installation

Please paste the contents of your packages.yml file here:

packages:
  - package: dbt-labs/dbt_utils
    version: 1.3.3

  - package: brooklyn-data/dbt_artifacts
    version: 2.10.0

  - package: metaplane/dbt_expectations
    version: 0.10.10

  - package: Snowflake-Labs/dbt_constraints
    version: 1.0.8

  - package: entechlog/dbt_snow_mask
    version: 0.2.8

  ...

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions