hi i want to add more custom columns to `dbt_invo...
# community-support
a
hi i want to add more custom columns to
dbt_invocations
table. is it possible? any documentation on the process? thanks in advance
m
Hi @Asaf Alina What columns are you thinking of adding?
a
we have dbt running in an airflow env, so i was thinking of adding cols such as
dag_id
,
dag_run_id
,
task_id
, etc... i eventually ended up creating a separate table for such data, but would be nice to know if/how its possible to add custom cols to elementary model.
m
Hi @Asaf Alina Actually, Elementary already supports collecting job information from orchestrators! You can find more information here: https://docs.elementary-data.com/cloud/guides/collect-job-data Let us know if it helps!
👀 1
a
@Mika Kerman thx, i ended up using the suggestions on the link 👍
m
Nice!!