Data stewardship for serving warehouse users

This section talks about conducting data stewardship for analyst users. First, we will cover setting up data access policies in order to provide access to all classes of users. Next, we will talk about how the act of structuring data in a warehouse or lake causes analysts to have needs for certain types of variables. We will discuss adding variables called foreign keys to the warehouse, and this is followed by a discussion of the development of crosswalk variables.

Providing data access

Restricting access to data to only those who should be approved is very important in a data system, regardless of whether it is a data lake or data warehouse. This section will describe how to set up an administrative process to grant access to analyst users while ensuring that data in the system is safeguarded.

Providing access to a data warehouse app

As mentioned earlier, analysts who access data through a data warehouse were classified as app...