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

Job	Run time
changes	8s
test-dbt-versions (1.4)	1m 35s
test-dbt-versions (1.8)	1m 44s
test-dbt-versions (1.10)	1m 48s
test-dbt-versions (1.7)	1m 47s
test-dbt-versions (1.6)	1m 35s
test-dbt-versions (1.9)	1m 46s
test-dbt-versions (1.5)	1m 28s
test-dbt-versions (1.3)	1m 38s
test-vscode	0s
test-vscode-e2e	0s
migration-test	1m 29s
doc-tests	32s
cicd-tests-windows	11m 8s
style-and-cicd-tests (3.9)	23m 39s
style-and-cicd-tests (3.11)	24m 24s
style-and-cicd-tests (3.13)	22m 51s
style-and-cicd-tests (3.10)	23m 59s
style-and-cicd-tests (3.12)	23m 33s
engine-tests-docker (mysql)	1m 36s
engine-tests-docker (postgres)	2m 29s
engine-tests-docker (mssql)	1m 51s
engine-tests-docker (clickhouse)	2m 42s
engine-tests-docker (risingwave)	2m 41s
engine-tests-docker (starrocks)	3m 1s
engine-tests-docker (trino)	8m 18s
engine-tests-docker (spark)	5m 1s
engine-tests-docker (duckdb)	1m 37s
ui-test	-1s
ui-style	-1s
engine-tests-cloud	-1s
	2h 54m 17s

Provide feedback