Pre-Installation: Set MariaDB Variables

About this task

MariaDB is installed in a single pass. Set CDM_DATABASE=MARIADB, review the files in configs/26.1.IF02/, and then run airflow_variable_sync_26.1_IF02, as described in Run Variable Sync. The host, port, user, and password are placeholders in ddl_execution_if02_mariadb.json.

Procedure

  1. Set the Airflow Variable CDM_DATABASE to MARIADB.
  2. Replace the host, port, user, and password placeholders in configs/26.1.IF02/ddl_execution_if02_mariadb.json.
  3. Trigger airflow_variable_sync_26.1_IF02 from the Airflow UI.

    The sync creates the following Airflow Variables:

    Airflow Variable Example Value Description
    CDM_DATABASEMARIADBTarget database type
    CDM_MARIADB_HOST<hostname>MariaDB host
    CDM_MARIADB_PORT3306MariaDB port
    CDM_MARIADB_CANONICAL_ETL_DB_USERcanonical_etl_db_userETL service account (CDM_MARIADB_USER)
    CDM_MARIADB_CANONICAL_ETL_DB_USER_PASSWORD<password>ETL service account password (CDM_MARIADB_PASSWORD)
    CDM_MARIADB_CHARSET / CDM_MARIADB_COLLATIONutf8mb4 / utf8mb4_general_ciCharacter set and collation used by the DDL
    CDM_MARIADB_DDL_START_POINT_26.1_IF02(empty or step ID)DDL resume point
    CDM_MARIADB_DDL_SCHEMA_26.1_IF02JSONStep list (19 steps)
    CDM_CUSTOMER_SOURCE_MARIADB_SCHEMAcanonicalSource schema for Bespoke ETL