Before You Start

Complete the following checks before you upgrade:

  • Back up the Airflow DAGs folder, the exported Airflow Variables, and the CDM database schemas.
  • Pause the schedules of cdm_grandmaster_dag and let the running DAGs finish.
  • Confirm that the IF02 virtual environment and Python packages are in place. For MariaDB, see Virtual Environment Setup.
  • Backup/truncate/drop tables as below:
    Action Schema Tables Back up first
    Truncate DEV_RAW UA_OFFERATTRIBUTE, UA_OFFERHISTORY, UA_OFFER_VARIANT, UA_OFFER_VARIANT_ATTRIBUTE, UA_OFFERLIST, UA_CAMPATTRIBUTE, UA_STO_METRICS, UA_CAMPTOOFFER, UA_OFFERHISTATTRIB, UA_CELLATTRIBUTE, UA_USRRESPONSETYPE, UA_CONTACTSTATUS, UA_ATTRIBUTEDEF, UA_COST_MAPPING, UA_CAMPAIGN, UA_OFFER, UA_TARGETCELLS, UA_TREATMENT, UA_AUDIENCES, UA_SEGMENT, UA_FLOWCHART, UA_CCRUNLOG, UA_TABLEMAPPINGXREF, UA_CH_PARTYID, UA_RH_PARTYID, UA_CH_ACCOUNT, UA_RH_ACCOUNT, UA_CH_DEVICE, UA_RH_DEVICE No
    Truncate DEV_BDV BDV_UA_ATTRIBUTEDEF_SNAPSHOT, BDV_UA_CAMPATTRIBUTE_SNAPSHOT, BDV_UA_CAMPTOOFFER_SNAPSHOT, BDV_UA_CELLATTRIBUTE_SNAPSHOT, BDV_UA_CONTACTSTATUS_SNAPSHOT, BDV_UA_OFFERATTRIBUTE_SNAPSHOT, BDV_UA_OFFERHISTATTRIB_SNAPSHOT, BDV_UA_OFFERHISTORY_SNAPSHOT, BDV_UA_OFFERLIST_SNAPSHOT, BDV_UA_OFFERLISTMEMBER_SNAPSHOT, BDV_UA_OFFER_VARIANT_SNAPSHOT, BDV_UA_OFFER_VARIANT_ATTRIBUTE_SNAPSHOT, BDV_UA_STO_METRICS_SNAPSHOT, BDV_UA_USRRESPONSETYPE_SNAPSHOT, BDV_UA_CCRUNLOG_SNAPSHOT, BDV_UA_FLOWCHART_SNAPSHOT, BDV_UA_TABLEMAPPINGXREF_SNAPSHOT, BDV_UA_DTL_CONTACT_HIST_SNAPSHOT, BDV_UA_DTL_ACCOUNT_CONTACT_HISTORY_SNAPSHOT, BDV_UA_DTL_DEVICE_CONTACT_HISTORY_SNAPSHOT No
    Truncate DEV_BDV BDV_UA_CONTACTHISTORY_SNAPSHOT, BDV_UA_RESPONSEHISTORY_SNAPSHOT, BDV_UA_ACCOUNT_CONTACTHISTORY_SNAPSHOT, BDV_UA_ACCOUNT_RESPONSEHISTORY_SNAPSHOT, BDV_UA_DEVICE_CONTACTHISTORY_SNAPSHOT, BDV_UA_DEVICE_RESPONSEHISTORY_SNAPSHOT Yes
    Truncate CS_360_DB CAMPAIGN_360, CUSTOMER_360, FLOWCHART_360 Yes
    Truncate DEV_RDV S_CAMPAIGN, S_OFFER, S_TARGETCELL, LSAT_TREATMENT_EXEC, S_AUDIENCE, S_SEGMENT, H_CAMPAIGN, H_OFFER, H_TARGETCELL, L_TREATMENT_EXEC, H_AUDIENCE, H_SEGMENT No
    Drop DEV_ANP ANP_CAMPAIGN_DELTA, ANP_OFFER_DELTA, ANP_TARGETCELL_DELTA, ANP_TREATMENT_EXEC_DELTA, ANP_AUDIENCE_DELTA, ANP_SEGMENT_DELTA, ANP_CAMPAIGN_SNAPSHOT, ANP_OFFER_SNAPSHOT, ANP_TARGETCELL_SNAPSHOT, ANP_TREATMENT_EXEC_SNAPSHOT, ANP_AUDIENCE_SNAPSHOT, ANP_SEGMENT_SNAPSHOT