Add env variables to configure manifest cache #7997

Job	Run time
integration-test	12m 13s
cibw-dev-env-smoke-test	27s
integration-test-adls	1m 24s
lint-and-unit-test (3.11)	2m 48s
lint-and-unit-test (3.12)	2m 59s
integration-test-gcs	1m 14s
integration-test-s3	1m 28s
lint-and-unit-test (3.13)	2m 54s
lint-and-unit-test (3.10)	2m 52s
integration-coverage-report	32s
	28m 51s

Provide feedback