[Bug]: ROWS_AFFECTED column in table FCT_DBT__MODEL_EXECUTIONS shows always 1

[sushildjoshi]

I added dbt_artifacts in my project and then run one model.

after this when I query this table for specific model run I can see rows_affected is always showing as 1 and not actual number of rows loaded as part of run.

as part of my run, there are 100 records loaded in my table so I am expecting same 100 value should show in column rows_affected present in table FCT_DBT__MODEL_EXECUTIONS .

please help to fix this as this will be big saver to quickly see how many records got loaded as part my latest model execution.

Thanks a lot in advance for all your help !

[jared-rimmer]

Hi @sushildjoshi are you able to provide any more context on this error:

• Version of dbt artifacts
• Version of dbt
• The database you're using
• The type of materialisation you're using for the table

• any more info you can provide to help us look into this for you