The problem I’m having
adjusting the priority attribute from the profiles.yml in a specific model config from interactive to batch doesn’t work. the bigquery job still runs in interactive mode
The context of why I’m trying to do this
changing the default from interactive to batch but only in specific models and not all of them
What I’ve already tried
when changed globally in profiles.yml it works.
changing in specific models doesn’t work.
I tried removing custom macros I have that maybe caused it but still the same results.
I’m using dbt-bigquery 1.5.0 with dbt-core 1.5.9 (tried also 1.5.11)
Some example code or error messages
here is the profiles.yml configuration example
type: bigquery
method: oauth
project: “{{ env_var(‘bq_project_id’) }}”
execution_project: “{{ env_var(‘composer_project_id’) }}”
dataset: DW_Logs
location: “{{ env_var(‘bq_location’) }}”
priority: interactive
threads: 10
timeout_seconds: 300
fixed_retries: 1
here is how the config looks like
{{
config(
materialized=‘incremental’,
priority=‘batch’,
unique_key=‘Platform_ID’,
)
}}
Is it possible to change the priority in a single model? if so, is it a bug?
Thanks is advance,