Hello there! I have a small issue with my

dbt_invocations

table, it seems like

job_name

is always null. We use dbt cloud, is there any way to fix this?

Hi @Marta Massarotti! dbt cloud doesn't automatically populate the job name so in order for us to access it and upload it to the

dbt_invocations

table - we will need you to add an environment variable called

DBT_JOB_NAME

with the name of your job to your job environment variables. Then it should be populated automatically in the

dbt_invocations

table. here's a screenshot where this should be added -

Amazing, I’ll try it out!

#C02CTC89LAX do we still have to set the DBT_JOB_NAME env variable in dbt Cloud for each dbt job individually? Or is there an alternative, more efficient way for Elementary to read the job_name?