Add env variables to configure manifest cache #7996

Job	Run time
integration-test-gcs	1m 5s
integration-test-adls	1m 10s
cibw-dev-env-smoke-test	25s
integration-test	1m 10s
lint-and-unit-test (3.12)	1m 7s
integration-test-s3	1m 4s
lint-and-unit-test (3.11)	1m 9s
lint-and-unit-test (3.10)	58s
lint-and-unit-test (3.13)	1m 6s
integration-coverage-report	1s
	9m 15s

Provide feedback