A contextual data lakehouse, combines the ability of a data lake to store large volumes of varied data at a lower cost with the management features and tools of a data warehouse. The data lakehouse stores data from multiple sources in a common format maintaining entity relationships, thus making it easier for a query engine to sift through and generate results quickly.