1. A method for utilizing an index to manage access to data in a dataset stored in one or more file locations in an ETL tool, the method comprising: receiving, by one or more processors, a request to access a dataset associated with one or more file locations, wherein the dataset is stored in the one or more file locations; querying, by one or more processors, an index for the one or more file locations associated with the dataset, wherein the dataset has another index for data in the dataset; receiving, by one or more processors, the one or more file locations associated with the dataset; and determining, by one or more processors, to cache the request to access the one or more file locations for the dataset until one or more thresholds are met, wherein the cached request is part of a total number of cached requests.