Add env variables to configure manifest cache #7994

Job	Run time
integration-test-s3	1m 15s
lint-and-unit-test (3.11)	1m 19s
lint-and-unit-test (3.10)	1m 21s
integration-test	1m 20s
lint-and-unit-test (3.12)	1m 20s
integration-test-gcs	1m 7s
cibw-dev-env-smoke-test	27s
lint-and-unit-test (3.13)	1m 20s
integration-test-adls	1m 12s
integration-coverage-report	1s
	10m 42s

Provide feedback