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