Verify DDL Execution

Procedure

  1. For Oracle, run:
    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');
  2. For SQL Server, run:
    SELECT name FROM sys.schemas
                            WHERE name IN ('DEV_RAW','DEV_LDZ','DEV_RDV','DEV_BDV','CS_360_DB','CDP_METADATA');
  3. For Snowflake, run:
    SHOW SCHEMAS IN DATABASE CDM_DB;