num_retries doesn't work with env_var

[hagai-arad]

Hi,

I'm using env_var in my profile.yml file, but when trying to set the num_retires attribute with env_var it fails with the following error:

ERROR: Runtime Error
  Credentials in profile "my_profile", target "dev" invalid: '0' is not valid under any of the given schemas

To set the env var I ran this: export DBT_ATHENA_NUM_RETRIES=0

My profile.yml:

my_profile:
  outputs:
    dev:
      database: "{{ env_var('DBT_ATHENA_DB') }}"
      region_name: "{{ env_var('DBT_REGION_NAME') }}"
      s3_staging_dir: "{{ env_var('DBT_S3_STAGING_DIR') }}"
      schema: "{{ env_var('DBT_ATHENA_SCHEMA') }}"
      type: athena
      num_retries: "{{ env_var('DBT_ATHENA_NUM_RETRIES') }}"
  target: dev

A few notes:

• When using the 0 directly it works fine: num_retries: 0
• The other attributes are assigned as expected using the env_var

[nicor88]

The issue is on how you use the "{{ env_var('DBT_ATHENA_NUM_RETRIES') }}" as it's rendered as a string, could you try
{{ env_var('DBT_ATHENA_NUM_RETRIES') }} without quotes?

[hagai-arad]

Already tried, it throws a syntax error.

I also tried:
export DBT_ATHENA_NUM_RETRIES='0'
and
export DBT_ATHENA_NUM_RETRIES="0"

[nicor88]

The issue seems to be on your side, you are passing a string to a value that should be an integer. Try this
"{{env_var('DBT_ATHENA_NUM_RETRIES') | int }}"

If you look at this docs https://docs.getdbt.com/reference/dbt-jinja-functions/env_var it give you the int on how to cast string as int :)

[hagai-arad]

You are right :)
Thanks!