Hi everyone!
I have a table called dim_date with information about dates, and a table called payments that has a column called date_key which is a foreign key to dim_date.
How can I test the freshness of the table payments if that table doesn’t have a timestamp column but has a foreign key to the table where the timestamp column is?
Thank you!