Add env variables to configure manifest cache #7999

Job	Run time
integration-test-s3	1m 10s
integration-test-gcs	1m 2s
integration-test-adls	1m 9s
integration-test	11m 0s
lint-and-unit-test (3.10)	3m 11s
lint-and-unit-test (3.12)	2m 54s
cibw-dev-env-smoke-test	27s
lint-and-unit-test (3.11)	2m 55s
lint-and-unit-test (3.13)	2m 59s
integration-coverage-report	33s
	27m 20s

Provide feedback