# Policy Tag Taxonomies in BigQuery + dbt

**URL:** <https://discourse.getdbt.com/t/policy-tag-taxonomies-in-bigquery-dbt/11811>\
**Category:** Help\
**Created:** [January 30, 2024, 10:57am UTC](https://discourse.getdbt.com/t/policy-tag-taxonomies-in-bigquery-dbt/11811 "2024-01-30T10:57:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![moseleyi](https://avatars.discourse-cdn.com/v4/letter/m/edb3f5/32.png) [@moseleyi](https://discourse.getdbt.com/u/moseleyi)\
**Post date:** [January 30, 2024, 10:57am UTC](https://discourse.getdbt.com/t/policy-tag-taxonomies-in-bigquery-dbt/11811/1 "2024-01-30T10:57:37Z")

</div>

Policy tags have to have the project name specified in its resource path, as well as the location. I don’t think the taxonomy (ies) are usually that big but the number of columns using them may be.

I wonder if anybody tried to write it as DRY as possible.

At the moment I add a policy tag in `resource.yml` file under columns:

```auto
policy_tags:
 
 - 'projects/{{target.project}}/locations/{{var("default_location")}}/taxonomies/6942516414247800377/policyTags/3505403136526480544'

```

The problem I see is that I would have to copy this whole resource path to every column where I need it. I thought about using `vars` for it:

```auto
vars: 
  policy_tag_email: 'projects/{{target.project}}/locations/{{var("default_location")}}/taxonomies/6942546414257800377/policyTags/3505403436526380544'

```

but I wouldn’t be able to use `{[target.project}}` or `var("default_location")` in the definition of vars, according to the documentation:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/getdbt/original/2X/0/02f6f6a564b7df656434a2ac02715e3172578a2a.png)

Taxonomies, in order to work, have to live in the project and I’m running DEV and PROD in separate projects. Location is just addition and I could make it hardcoded but the `{{target.project}}` problem still persists.

---

<div class="post-metadata">

**Author:** ![McNamara](https://avatars.discourse-cdn.com/v4/letter/m/57b2e6/32.png) [@McNamara](https://discourse.getdbt.com/u/McNamara)\
**Post date:** [August 14, 2024, 12:20pm UTC](https://discourse.getdbt.com/t/policy-tag-taxonomies-in-bigquery-dbt/11811/2 "2024-08-14T12:20:04Z")

</div>

Did you find a solution to make policy tags more convenient to use in dbt yaml ?