[Backport 1.7.latest] Implementation of metadata-based freshness (#721) #5411

Job	Run time
test-metadata	5s
redshift / python 3.8 / ubuntu-latest	30m 19s
redshift / python 3.9 / ubuntu-latest	31m 4s
redshift / python 3.10 / ubuntu-latest	30m 7s
redshift / python 3.11 / ubuntu-latest	26m 55s
redshift / python 3.8 / windows-latest	31m 45s
redshift / python 3.8 / macos-latest	23m 25s
require-label-comment	10s
post-failure	0s
	2h 53m 50s

Provide feedback