Variables, functions or macros for audit, metadata fields for each data row

Archive
1

Hello,
I’m looking for a way to have these fields for every record in the database:

  1. When record was created/updated
  2. What user ID created/updated record
  3. What model created/updated record
  4. What version of model created/updated record

I’m from Informatica, Oracle ODI ETL tools background and usually they had out of box variables to provide execution context for each record. Is there is anything from dbt core, or dbt packages that can achieve all/any of above requirements?

2

Are you talking about SCD2?
I believe that behavior falls under dbt snapshots.

P.S, I’m from same informatica/oracle background.