Validation Steps

• Oracle:

  SELECT username FROM dba_users
  WHERE username IN ('DEV_RAW','DEV_LDZ','DEV_ANP','DEV_RDV','DEV_BDV',
    'CS_360_DB','CDP_METADATA','IM_CDP_DB','CDM_INGEST_DB','CDM_PUBLISH_DB');

• SQL Server

  SELECT name FROM sys.schemas
  WHERE name IN ('DEV_RAW','DEV_LDZ','DEV_RDV','DEV_BDV','CS_360_DB','CDP_METADATA');

• Snowflake

  SHOW SCHEMAS IN DATABASE CDM_DB;

• MariaDB

  SELECT schema_name FROM information_schema.schemata WHERE schema_name IN ('canonical','cdp_metadata','dev_ldz','dev_anp','dev_stg', 'dev_raw','dev_rdv','dev_bdv','im_cdp_db','cs_360_db','cdm_ingest_db','cdm_publish_db');

SELECT COUNT(*) FROM CS_360_DB.CUSTOMER_360;

SELECT COUNT(*) FROM CS_360_DB.CAMPAIGN_360;

SELECT COUNT(*) FROM CS_360_DB.FLOWCHART_360;

SELECT * FROM CDP_METADATA.ETL_DATE_CONTROL;

SELECT owner, table_name FROM dba_tables WHERE
  (owner='DEV_LDZ' AND table_name IN (
     'LDZ_CHANNEL_COST_MASTER','LDZ_CONVERSION','LDZ_PRODUCT_MAPPING',
     'LDZ_UA_CT_CONTACTHISTORY','LDZ_UA_CT_RESPONSEHISTORY'))
  OR (owner='DEV_BDV' AND table_name IN (
     'AGG_CUSTOMER','AGG_CAMPAIGN','FACT_CONVERSION',
     'BDV_AUDIENCE_LEVEL_MAPPING','BDV_CHANNEL_COST_MASTER_SNAPSHOT',
     'BDV_CONVERSION_SNAPSHOT','BDV_PRODUCT_MAPPING_SNAPSHOT',
     'BDV_UA_COMBINED_CONTACTHISTORY_SNAPSHOT',
     'BDV_UA_COMBINED_RESPONSEHISTORY_SNAPSHOT'))
  OR (owner='CDM_INGEST_DB' AND table_name IN (
     'PROFILE','ID_MAPPING','EVENT','METADATA'))
  OR (owner='CDP_METADATA' AND table_name='CDM_REFERENCE_DATA_HUB');

SQL Server, Snowflake and MariaDB: check the same table names in the schemas dev_ldz, dev_bdv, cdm_ingest_db and cdp_metadata (for example with INFORMATION_SCHEMA.TABLES).

In the Airflow UI, confirm that ddl_execution_26.1_IF02_IF02_IF02_IF02_IF02 finished with all tasks green and that cdm_grandmaster_dag lists the DAGs of Section 8.2 without import errors (Browse > DAG Import Errors).