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

Job	Run time
changes	8s
test-dbt-versions (1.5)	1m 23s
test-dbt-versions (1.3)	1m 47s
test-dbt-versions (1.6)	1m 42s
test-dbt-versions (1.7)	1m 50s
test-dbt-versions (1.9)	1m 50s
test-dbt-versions (1.4)	1m 40s
test-dbt-versions (1.10)	1m 55s
test-dbt-versions (1.8)	1m 26s
test-vscode	-1s
test-vscode-e2e	-1s
migration-test	1m 35s
doc-tests	34s
style-and-cicd-tests (3.13)	24m 35s
style-and-cicd-tests (3.12)	16m 26s
style-and-cicd-tests (3.10)	24m 53s
style-and-cicd-tests (3.9)	19m 3s
cicd-tests-windows	11m 37s
engine-tests-docker (duckdb)	1m 44s
style-and-cicd-tests (3.11)	25m 33s
engine-tests-docker (trino)	8m 44s
engine-tests-docker (postgres)	2m 16s
engine-tests-docker (mssql)	2m 0s
engine-tests-docker (mysql)	1m 41s
engine-tests-docker (risingwave)	2m 48s
engine-tests-docker (clickhouse)	2m 43s
engine-tests-docker (spark)	6m 7s
engine-tests-docker (starrocks)	2m 41s
ui-style	0s
ui-test	0s
engine-tests-cloud	0s
	2h 48m 39s

Provide feedback