Add env variables to configure manifest cache #7998

Job	Run time
integration-test-gcs	1m 22s
integration-test-s3	1m 14s
cibw-dev-env-smoke-test	26s
integration-test-adls	1m 9s
integration-test	5m 22s
lint-and-unit-test (3.11)	2m 54s
lint-and-unit-test (3.13)	2m 48s
lint-and-unit-test (3.10)	3m 1s
lint-and-unit-test (3.12)	2m 59s
integration-coverage-report	1s
	21m 16s

Provide feedback