Yesterday I got an inquiry from a teammate asking if it's possible to automatically update a value of the column whenever it gets updated. Instantly thought of Postgres or MySQL capability to have this column that is updated automatically on a trigger (say when it gets updated) -- like an updated_at or some sort.

As it turns out Redshift does not support the same functionality (probably because it's not really a database, but a warehouse).

Sources:

- MySQL support @ Medium
- Redshift @ StackOverflow