Generate prep table creation files and configuration for ID unification
Generates prep table creation files and configuration for ID unification workflows.
/plugin marketplace add treasure-data/aps_claude_tools/plugin install treasure-data-cdp-unification-plugins-cdp-unification@treasure-data/aps_claude_toolsI'll generate prep table creation files and configuration using the dynamic-prep-creation specialized agent.
This command creates PRODUCTION-READY prep table files:
If you've already run key extraction:
/cdp-unification:unify-extract-keysOR provide directly:
mck, client_name)src)stg)config)For each table, specify which columns to include and their unified aliases:
emailphonecustomer_idtd_client_idtd_global_idI'll create:
unification/config/ directoryunification/queries/ directoryI'll create these files with ZERO MODIFICATIONS:
⚠️ unification/dynmic_prep_creation.dig (EXACT filename - no 'a' in dynmic)
⚠️ unification/queries/create_schema.sql
⚠️ unification/queries/loop_on_tables.sql
⚠️ unification/queries/unif_input_tbl.sql
unification/config/environment.yml
client_short_name: {your_client_name}
src: src
stg: stg
gld: gld
lkup: references
unification/config/src_prep_params.yml
For unif_input_tbl.sql, I'll:
information_schema.columnsunification/
├── dynmic_prep_creation.dig ⚠️ EXACT filename
├── queries/
│ ├── create_schema.sql ⚠️ EXACT content
│ ├── loop_on_tables.sql ⚠️ EXACT content
│ └── unif_input_tbl.sql ⚠️ WITH dynamic columns
unification/config/
├── environment.yml ✓ Client-specific
└── src_prep_params.yml ✓ Table-specific
globals:
unif_input_tbl: unif_input
prep_tbls:
- src_tbl: user_events
src_db: ${client_short_name}_${stg}
snk_db: ${client_short_name}_${stg}
snk_tbl: ${src_tbl}_prep
columns:
- col:
name: user_email
alias_as: email
- col:
name: td_client_id
alias_as: td_client_id
- src_tbl: customers
src_db: ${client_short_name}_${stg}
snk_db: ${client_short_name}_${stg}
snk_tbl: ${src_tbl}_prep
columns:
- col:
name: email
alias_as: email
- col:
name: customer_id
alias_as: customer_id
time column to src_prep_params.ymlBefore completing, I'll verify:
All generated files will:
After prep creation, you can:
dig run unification/dynmic_prep_creation.dig/cdp-unification:unify-create-config/cdp-unification:unify-setupReady to create prep tables? Please provide:
Table list with columns:
Table: analytics.user_events
Columns: user_email (email), td_client_id (td_client_id)
Table: crm.customers
Columns: email (email), customer_id (customer_id)
Client configuration:
Client short name: mck
I'll call the dynamic-prep-creation agent to generate all prep files with exact templates.
Let's create your prep table configuration!