Manual Schema Creation (DBA Step)
Procedure
- Log in to the Oracle server using DBA credentials.
- Navigate to ddls/oracle_ddls/ in the extracted CDM package.
- Open Step1_user_schema_creation.sql and replace all instances of <password> with actual secure passwords.
-
Execute the script as SYSDBA or equivalent:
@Step1_user_schema_creation.sqlWarning: Create users WITHOUT double quotes to avoid case-sensitivity issues.Correct: CREATE USER DEV_LDZ IDENTIFIED BY YourSecurePassword;Incorrect: CREATE USER "DEV_LDZ" IDENTIFIED BY YourSecurePassword;
What to do next
| Schema | Description |
|---|---|
| canonical | Standardised source layout (Bespoke ETL source) |
| dev_raw | History-preserving raw ingestion layer |
| dev_ldz | CDC-operational Landing Zone |
| dev_rdv | Raw Data Vault (Hub, Link, Satellite) |
| dev_bdv | Business Data Vault (campaign snapshots) |
| cs_360_db | Customer 360 core tables |
| cdp_metadata | ETL control and reference data |
| im_cdp_db | Dimensional and fact views |
| cdm_ingest_db | ML prediction ingestion layer |
| cdm_publish_db | CDM published views layer |
Note: If schema names are changed from the defaults, update the corresponding Airflow variables accordingly. Always provide schema names in UPPERCASE in Airflow variables.