Skip to main content

Adding Data to the RAE

Requests to add data to Ohio State University’s Reporting and Analytics Environment (RAE), hosted on Amazon Redshift, must follow a structured intake and approval process involving Data Steward approval, prioritization, domain classification by Data Governance, and coordination with Data Engineering for secure integration.

Requested by Data Steward or Pre-Approval from Data Steward

  1. The data steward or user with pre-approval, should submit a request via the Project Intake form.
    1. In the project intake form, the Service Area should be OTDI – Data Management.
    2. The Service Area Portfolio Team should be Data Engineering.
    3. If the requestor is not the data steward, please attach an email under Supportive Documents with the Data Steward’s approval.
    4. Pro-Tip: If the goal is for the data to be in Tableau or a single source of truth, specify in the project summary that you would like business logic included in views. You must know what the business logic is (or know someone who does), Data Engineers will work with technical and business analysts in the unit as part of the project to build views in the silver or gold layers of the RAE that contain the business logic. This will make it easier for users to create Tableau dashboards or write SQL queries.
  2. The request will be prioritized by against all the other work, with input from data and analytics leadership across the university and/or business sponsor meetings.
  3. Once the request moves forward in the queue,
    1. The Data Engineering team will send an email to DataGovernance@osu.edu with context of the project. The requester will be cc’d. The context of the email will ask for Data Governance to classify the data into a domain.
    2. Data Governance will then initiate communication with the requestor, data steward, and other necessary stakeholders to ensure data steward approval for loading the data into the RAE and securing a domain classification for the data.
      1. If the data is a new domain or subdomain, Data Governance will work with stewards and stakeholders to determine the new domain.
      2. Once the new domain or subdomain is approved, Data Governance will notify the following teams in OTDI: Data Engineers, Access Management, ServiceNow, Marketing & Communications, and Data Visualization. The Data Governance team is responsible for coordinating work between OTDI groups and communicating with the requestor and data stewards once the work is completed.
    3. Data Governance will request via ServiceNow for the Data Engineers to add objects to the appropriate domains.
    4. Data Engineers will add an entry into the RAE-Arbiter security file, which will apply the permissions in the RAE. If necessary, this step can be delayed until go-live. 

Requested by someone other than the Data Steward

  1. The user should submit a request via the Project Intake form.
    1. In the project intake form, the Service Area should be OTDI – Data Management. 

    2. The Service Area Portfolio Team should be Data Engineering. 

       

      Note: If the goal is for the data to be in Tableau or a single source of truth, specify in the project summary that you would like business logic included in views. You must know what the business logic is (or know someone who does), Data Engineers will work with technical and business analysts in the unit as part of the project to build views in the silver or gold layers of the RAE that contain the business logic. This will make it easier for users to create Tableau dashboards or write SQL queries.

  2. The Data Engineering team will review to determine the feasibility of the request. If the project appears feasible, the Data Engineers will email Data Governance.
  3. Data Governance will handle Data Steward approval and classifying the data into a domain.
  4. Once the request moves forward in the queue,
    1. The Data Engineering team will send an email to DataGovernance@osu.edu with context of the project. The requester will be cc’d. The context of the email will ask for Data Governance to classify the data into a domain.
    2. Data Governance will then initiate communication with the requestor, data steward, and other necessary stakeholders to ensure data steward approval for loading the data into the RAE and securing a domain classification for the data.
      1. If the data is a new domain or subdomain, Data Governance will work with stewards and stakeholders to determine the new domain.
      2. Once the new domain or subdomain is approved, Data Governance will notify the following teams in OTDI: Data Engineers, Access Management, ServiceNow, Marketing & Communications, and Data Visualization. The Data Governance team is responsible for coordinating work between OTDI groups and communicating with the requestor and data stewards once the work is completed.
    3. Data Governance will request via ServiceNow for the Data Engineers to add objects to the appropriate domains.
    4. Data Engineers will add an entry into the RAE-Arbiter security file, which will apply the permissions in the RAE. If necessary, this step can be delayed until go-live.