Hi data team...
We're releasing our EDW as we've finished re-create, re-map, re-design all existing ETL script in DW to EDW.
EDW schema and semantics exploration could be found here : https://docs.google.com/spreadsheets/d/1S3awLfP6iB-BO_pBxjI-Tn6xHnn-lnoKhhpdjKkkaYk/edit#gid=429861884
Here's the map of existing tables in DW and EDW tables, so you could start to migrate all your dashboards as per today:
1 dw.dim_airline_info >>> edw.dim_airline
2 dw.dim_airport_info >>> edw.dim_airport
3 dw.dim_bank_iin >>> edw.dim_bank_iin
4 dw.dim_commerce_voucher >>> edw.dim_commerce_coupon
5 dw.dim_country >>> edw.dim_country
6 dw.dim_currency >>> edw.dim_currency
7 dw.dim_geo_region >>> edw.dim_geo_region
8 dw.dim_currency_conversiontable >>> edw.fact_currency_conversion_rate
9 dw.dim_hotel >>> edw.dim_hotel
10 dw.dim_hotel_room >>> edw.dim_hotel_room
11 dw.dim_landmark >>> edw.dim_landmark
12 dw.dim_lang >>> edw.dim_language
13 dw.dim_saved_payment_method >>> edw.dim_saved_payment_method
14 dw.dim_tera_agent >>> edw.dim_tera_agent
15 dw.dim_tera_hotel_cancellation_policy >>> edw.dim_tera_hotel_cancellation_policy
16 dw.dim_tera_hotel_promo_rule >>> edw.dim_tera_hotel_promo_rule
17 dw.dim_tera_hotel_promo_rule_specific_nights >>> edw.dim_tera_hotel_promo_rule_specific_nights
18 dw.dim_tera_hotel_promo_rule_specific_rooms >>> edw.dim_tera_hotel_promo_rule_specific_rooms
19 dw.dim_tera_hotel_staff_contact >>> edw.dim_tera_hotel_staff
20 dw.dim_tera_hotel_tax_rule >>> edw.dim_tera_hotel_tax_rule
21 dw.dim_tera_room_rate_rule_scale >>> edw.dim_tera_room_rate_rule_scale
22 dw.fact_app_login_onboarding >>> edw.fact_mobile_app_login_onboarding
23 dw.fact_app_onboarding >>> edw.fact_mobile_app_install_onboarding
24 dw.fact_booking_refund >>> edw.fact_booking_refund
25 dw.fact_bulk_message_job >>> edw.fact_bulk_message_job
26 dw.fact_bulk_message_job_item >>> edw.fact_bulk_message_job_item
27 dw.fact_commerce_booking_coupon >>> edw.fact_commerce_booking_coupon
28 dw.fact_commerce_payment_selected >>> edw.fact_commerce_payment_selected
29 dw.fact_commerce_spmclientevent >>> edw.fact_commerce_spm_client_event
30 dw.fact_coupon_apply_track >>> edw.fact_coupon_apply_track
31 dw.fact_flight_booking_review_submitted >>> edw.fact_flight_booking_review_submitted
32 dw.fact_flight_booking_submitted >>> edw.fact_flight_booking
33 dw.fact_flight_issued >>> edw.fact_flight_booking
34 dw.fact_flight_itinerary_issued >>> edw.fact_flight_itinerary_booking
35 dw.fact_flight_redirect >>> edw.fact_flight_redirect
36 dw.fact_flight_reschedule_booking_review >>> edw.fact_flight_reschedule_booking_review
37 dw.fact_flight_reschedule_button_clicked >>> edw.fact_flight_reschedule_button_clicked
38 dw.fact_flight_reschedule_cancellation >>> edw.fact_flight_reschedule_cancellation
39 dw.fact_flight_reschedule_cashback >>> edw.fact_flight_reschedule_cashback_submitted
40 dw.fact_flight_reschedule_oldflight_selected >>> edw.fact_flight_reschedule_detail_selected
41 dw.fact_flight_reschedule_payment >>> edw.fact_flight_reschedule_payment_selected
42 dw.fact_flight_reschedule_payment_out >>> edw.fact_flight_reschedule_payment_out
43 dw.fact_flight_reschedule_redirect >>> edw.fact_flight_reschedule_redirect
44 dw.fact_flight_reschedule_request >>> edw.fact_flight_reschedule_request
45 dw.fact_flight_reschedule_search >>> edw.fact_flight_reschedule_search
46 dw.fact_flight_search >>> edw.fact_flight_search
47 dw.fact_flight_search_accuracy >>> edw.fact_flight_price_accuracy
48 dw.fact_flight_segment_issued >>> edw.fact_flight_segment_booking
49 dw.fact_flight_visit >>> edw.fact_flight_visit
50 dw.fact_hotel_booking >>> edw.fact_hotel_booking
51 dw.fact_hotel_issued >>> edw.fact_hotel_booking
52 dw.fact_hotel_pre_booking >>> edw.fact_hotel_pre_booking
53 dw.fact_hotel_review >>> edw.fact_hotel_review
54 dw.fact_hotel_review_schedule >>> edw.fact_hotel_review_schedule
55 dw.fact_hotel_search_hotels >>> edw.fact_hotel_search_hotels
56 dw.fact_hotel_search_rooms >>> edw.fact_hotel_search_rooms
57 dw.fact_hotel_survey >>> edw.fact_hotel_booking_survey
58 dw.fact_hotel_visit >>> edw.fact_hotel_visit
59 dw.fact_insurance_purchase >>> edw.fact_insurance_purchase
60 dw.fact_payment_fetched >>> edw.fact_payment_fetched
61 dw.fact_payment_invoice >>> edw.fact_payment_invoice
62 dw.fact_payment_received >>> edw.fact_payment_received
63 dw.fact_payment_request >>> edw.fact_payment_request
64 dw.fact_post_payment >>> edw.fact_post_payment
65 dw.fact_promo_list_viewed >>> edw.fact_promo_list_viewed
66 dw.fact_push_notification >>> edw.fact_mobile_app_deeplink
67 dw.fact_refund_action_log >>> edw.fact_refund_action_log
68 dw.fact_tera_hotel_activation_log >>> edw.fact_tera_hotel_activation_log
69 dw.fact_tera_hotel_invoice >>> edw.fact_tera_hotel_invoice
70 dw.fact_tera_hotel_live_summary >>> edw.fact_tera_hotel_live_summary
71 dw.fact_tera_hotel_reservation >>> edw.fact_tera_hotel_reservation
72 dw.fact_tera_responsible_agent_log >>> edw.fact_tera_responsible_agent_log
73 dw.fact_tera_room_rate_rule >>> edw.fact_tera_room_allotment_rate_rule
74 dw.fact_tvlk_visit >>> edw.fact_tvlk_visit
75 dw.fact_user_change_newsletter_preference >>> edw.fact_user_change_newsletter_preference
76 dw.fact_user_change_password >>> edw.fact_user_change_password
77 dw.fact_user_custom_itineraries >>> edw.fact_user_get_custom_itineraries
78 dw.fact_user_remove_login >>> edw.fact_user_remove_login
79 dw.fact_user_request_add_login >>> edw.fact_user_request_add_login
80 dw.fact_user_request_invitation_newsletter >>> edw.fact_user_request_invitation_newsletter
81 dw.fact_user_reset_password >>> edw.fact_user_reset_password
82 dw.fact_user_self_service_refund >>> edw.fact_user_self_service_refund
83 dw.fact_user_share_receipt >>> edw.fact_user_share_receipt
84 dw.fact_user_share_ticket >>> edw.fact_user_share_ticket
85 dw.fact_user_sign_in >>> edw.fact_user_sign_in
86 dw.fact_user_sign_out >>> edw.fact_user_sign_out
87 dw.fact_user_sign_up >>> edw.fact_user_sign_up
88 dw.fact_user_sms >>> edw.fact_user_sent_sms
89 dw.fact_user_stop_mailing_list >>> edw.fact_user_stop_mailing_list
90 dw.fact_user_subscribe_all_topic_newsletter >>> edw.fact_user_subscribe_all_topic_newsletter
91 dw.fact_user_upcoming_itineraries >>> edw.fact_user_get_upcoming_itineraries
92 dw.fact_user_verify_login >>> edw.fact_user_verify_login
93 dw.fact_zendesk_tickets >>> edw.fact_zendesk_tickets
94 dw.track_hotel_select_hotel >>> edw.fact_hotel_select_hotel
95 dw.track_mobileapp_check_in_help_call >>> edw.fact_mobile_app_check_in_help_call
96 dw.track_tera_visit_page >>> edw.fact_tera_visit_page
97 dw.track_tvlk_paid_page_view >>> edw.fact_tvlk_paid_page_view
You may start migrating from non-risky dashboards.
We're still optimizing some scripts to meet 6 hours SLA and other reliability issues (by end of February).
Should you need to prioritized your table reliability, you could contact Nisrina directly.
Should you find any anomaly data, you could contact Colin for data quality concern.
Do note, these tables might not have historical data. The data will be fully loaded by the end of February.
Thanks to AN team for the hard work.
Happy data analyzing!!!
:)