feat(janitor): add scoped snapshot cleanup for invalidated environments #3894

Job	Run time
test-dbt-versions (1.7)	1m 42s
changes	7s
test-dbt-versions (1.9)	1m 53s
test-dbt-versions (1.4)	1m 29s
test-dbt-versions (1.6)	1m 37s
test-dbt-versions (1.8)	1m 42s
test-dbt-versions (1.3)	1m 39s
test-dbt-versions (1.10)	1m 54s
test-dbt-versions (1.5)	1m 32s
test-vscode-e2e	0s
test-vscode	0s
doc-tests	28s
migration-test	1m 33s
style-and-cicd-tests (3.13)	18m 9s
style-and-cicd-tests (3.12)	21m 32s
style-and-cicd-tests (3.10)	22m 33s
engine-tests-docker (starrocks)	2m 40s
style-and-cicd-tests (3.9)	21m 16s
engine-tests-docker (postgres)	2m 30s
engine-tests-docker (risingwave)	2m 44s
style-and-cicd-tests (3.11)	21m 39s
engine-tests-docker (mysql)	1m 46s
engine-tests-docker (clickhouse)	2m 46s
engine-tests-docker (spark)	5m 10s
engine-tests-docker (duckdb)	1m 31s
engine-tests-docker (mssql)	1m 57s
engine-tests-docker (trino)	7m 49s
ui-test	0s
cicd-tests-windows	11m 34s
ui-style	0s
engine-tests-cloud	-1s
	2h 41m 11s

Provide feedback