# installing dbt packages where we have multiple dev and prod data lake, data warehouse, and data mart environments in bigquery

**URL:** <https://discourse.getdbt.com/t/installing-dbt-packages-where-we-have-multiple-dev-and-prod-data-lake-data-warehouse-and-data-mart-environments-in-bigquery/18054>\
**Category:** Help\
**Tags:** best-practice, bigquery, dbt-core\
**Created:** [February 5, 2025, 6:49pm UTC](https://discourse.getdbt.com/t/installing-dbt-packages-where-we-have-multiple-dev-and-prod-data-lake-data-warehouse-and-data-mart-environments-in-bigquery/18054 "2025-02-05T18:49:25Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![bparbhu](https://avatars.discourse-cdn.com/v4/letter/b/96bed5/32.png) [@bparbhu](https://discourse.getdbt.com/u/bparbhu)\
**Post date:** [February 5, 2025, 6:49pm UTC](https://discourse.getdbt.com/t/installing-dbt-packages-where-we-have-multiple-dev-and-prod-data-lake-data-warehouse-and-data-mart-environments-in-bigquery/18054/1 "2025-02-05T18:49:25Z")

</div>

Right now I’m trying to install dbt packages where we are trying to utilize packages that are sourced from our dev and prod data lake environments and then create stg reports in dev and prod data warehouse and then ultimately mart models in our dbt prod and dev data marts.

What is the best way to install dbt packages so that they target dev and prod data lakes at the same time and also how can I make sure that we take the same approach with each package we want to use going forward.

right now I’m doing this

target-path: “target”  
clean-targets:

- “target”
- “dbt\_packages”

vars:  
fivetran\_\_remove\_empty\_table\_warnings: true  
project\_data\_lake: “{{ ‘prod-data-lake’ if target.name == ‘prod’ else ‘dev-data-lake’ }}”  
project\_data\_warehouse: “{{ ‘prod-data-warehouse’ if target.name == ‘prod’ else ‘dev-data-warehouse’ }}”  
project\_data\_mart: “{{ ‘prod-data-mart’ if target.name == ‘prod’ else ‘dev-data-mart’ }}”

# five tran ad reporting package variables turn off any source that we do not use or have

ad\_reporting\_\_amazon\_ads\_enabled: False  
ad\_reporting\_\_apple\_search\_ads\_enabled: False  
ad\_reporting\_\_facebook\_ads\_enabled: True  
ad\_reporting\_\_google\_ads\_enabled: True  
ad\_reporting\_\_linkedin\_ads\_enabled: False  
ad\_reporting\_\_microsoft\_ads\_enabled: False  
ad\_reporting\_\_pinterest\_ads\_enabled: False  
ad\_reporting\_\_reddit\_ads\_enabled: False  
ad\_reporting\_\_snapchat\_ads\_enabled: False  
ad\_reporting\_\_tiktok\_ads\_enabled: False  
ad\_reporting\_\_twitter\_ads\_enabled: False  
ad\_reporting\_\_account\_passthrough\_metrics:  
- name: view\_through\_conversions  
ad\_reporting\_\_campaign\_passthrough\_metrics:  
- name: total\_shares  
ad\_reporting\_\_ad\_group\_passthrough\_metrics:  
- name: interactions  
ad\_reporting\_\_ad\_passthrough\_metrics: ## For both Ad and URL reports  
- name: video\_views\_captured  
ad\_reporting\_\_keyword\_passthrough\_metrics:  
- name: interactions  
ad\_reporting\_\_search\_passthrough\_metrics:  
- name: local\_spend\_amount  
ad\_reporting\_\_url\_report\_\_using\_null\_filter: False

facebook\_ads\_schema: fb\_ads\_data  
facebook\_ads\_database: “{{ var(‘project\_data\_lake’, ‘dev-data-lake’) }}”

google\_ads\_schema: google\_ads\_data  
google\_ads\_database: “{{ var(‘project\_data\_lake’, ‘dev-data-lake’) }}”

though in the past when I’ve had to do our own proprietary models this usually works

Any help with this, is much appreciated.