Verify DDL Execution
Procedure
-
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'); -
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'); -
For Snowflake, run:
SHOW SCHEMAS IN DATABASE CDM_DB;