...

Bold views are final views in use by other systems

• blue-data (Lambda)

• blue-batch (Batch)

• Denodo

  • education_technology

    • 01-base_layer

      • 01-connections

        • coursescore

        • instructorscore

        • get_blue_api_key

        • getallprojectmetadata

      • 02-base_views

        • bv_coursescore

        • bv_get_blue_api_key

        • bv_getallprojectmetadata

        • bv_instructorscore

    • 02-transformation

      • blue

        • p_coursescore

        • p_instructorscore

        • p_blue_secondary_subject

        • p_blue_subject

        • p_course_evaluation

        • p_course_evaluation_fltr

    • 03-integration

      • j_coursescore_apikey_projectmetadata

      • j_coursescore_vw

      • j_getallprojectmetadata_api_key

      • j_instructorscore_apikey_projectmetadata

      • j_instructorscore_vw

      • j_blue_loaded_projects

      • j_blue_project_load_list

      • j_blue_secondary_subject_detail

      • j_blue_subject_detail

      • j_course_evaluation_all

    • 04-interface_fulfillment

      • coursescore_vw

      • instructorscore_vw

• Denodo Scheduler

  • blue_data_cache

Loading of Blue Data into Aurora DW

The AWS batch job blue-batch linked above is responsible for loading Blue data into the Aurora DW which course_evaluation views in Denodo rely on. The jobs runs weekly for each environment. The job loads projects based on the output of j_project_load_list in Denodo. The job also relies on bv_get_blue_api_key which returns the API key from Secrets Manager via Denodo.

Changes between Denodo and DW course_evaluation

...