Auditing Changes with a Trigger
Learn about setup for capturing and implementing code to audit changes.
We'll cover the following...
Setup for capturing changes
First, we need some setup:
-
We’re going to track changes made when we update the MoMA collection, which we processed in “Batch Update, MoMA Collection.” The table we’re auditing is
moma.artist. -
The changes are recorded in a table named
moma.audit, defined in a pretty generic way as we can see below. -
Then we ...