Pre-Installation: Set Snowflake Variables

About this task

Variable Example Value Description
CDM_DATABASESNOWFLAKETarget database type
CDM_SNOWFLAKE_ACCOUNTxy12345.us-east1Snowflake account identifier
CDM_SNOWFLAKE_CANONICAL_ETL_DB_USERCDM_ETL_USERETL service account
CDM_SNOWFLAKE_CANONICAL_ETL_DB_USER_PASSWORD<password>ETL service account password
CDM_SNOWFLAKE_DATABASECDM_DBSnowflake target database
CDM_SNOWFLAKE_DDL_START_POINT(empty or step ID)DDL resume point
CDM_SNOWFLAKE_DDL_SCHEMAschemacontains details such as ID, filename, username, and password required for execution.
CDM_CUSTOMER_SOURCE_SNOWFLAKE_SCHEMAschemaused for the canonical schema.
SCRIPTS_BASE_PATH/opt/unica/cdm/scriptsBase directory containing CDM ETL and orchestration scripts
UNICA_VENV_PYTHON_PATH/opt/unica/venv/bin/pythonPython executable path for the CDM virtual environment
CDM_360_ML_DBT_PROJECT_DIR/opt/unica/cdm/dbt/360_mlDBT project directory for Customer 360, Campaign 360, Flowchart 360, and ML models
CDM_360_ML_DBT_LOG_PATH/opt/unica/cdm/logs/dbt/360_mlLog directory for 360 and ML DBT execution logs
CDM_ANP_RDV_BDV_DBT_PROJECT_DIR/opt/unica/cdm/dbt/anp_rdv_bdvDBT project directory for ANP, RDV, and BDV transformation models
CDM_ANP_RDV_BDV_DBT_LOG_PATH/opt/unica/cdm/logs/dbt/anp_rdv_bdvLog directory for ANP, RDV, and BDV DBT execution logs

Schema name variables (defaults):

Variable Default
CDM_SNOWFLAKE_360_SCHEMACS_360_DB
CDM_SNOWFLAKE_BDV_SCHEMADEV_BDV
CDM_SNOWFLAKE_METADATA_SCHEMACDP_METADATA
CDM_SNOWFLAKE_INGEST_DB_SCHEMACDM_INGEST_DB
CDM_SNOWFLAKE_LDZ_SCHEMADEV_LDZ
CDM_SNOWFLAKE_ANP_SCHEMADEV_ANP
CDM_SNOWFLAKE_RDV_SCHEMADEV_RDV
CDM_SNOWFLAKE_RAW_SCHEMADEV_RAW
CDM_SNOWFLAKE_DIM_MODEL_SCHEMAIM_CDP_DB
CDM_SNOWFLAKE_CDM_PUBLISH_DB_SCHEMACDM_PUBLISH_DB

Procedure

Map the required parameters inside Airflow Admin Variable registry settings.