What is identity stitching in Treasure Data?

Identity stitching is the process of linking multiple event records to a single real-time profile using identifier keys. When different profiles share a key, Treasure Data merges them into a single profile.

What requirements are needed to use this skill?

You must provide a numeric Parent Segment ID and have the Treasure Data MCP server (@treasuredata/mcp-server) or tdx-skill configured with a valid API key.

Can I see which attributes triggered a profile creation?

Yes, the skill queries the current_id_attributes column during 'profile_added' events to show the initial keys and values associated with a new profile.

How does the skill handle time-based queries?

If no time range is specified, the skill defaults to the last 24 hours using the TD_INTERVAL function and formats timestamps into human-readable strings.

Treasure Data Identity Stitching

Name: Treasure Data Identity Stitching
Author: treasure-data

bytreasure-data

•

분석 및 모니터링

Analyzes and explores Treasure Data real-time profile creation and identity stitching history.

소개

This skill empowers developers to investigate Treasure Data's real-time identity resolution by querying identity change logs. It enables deep exploration of how profiles are created, updated, or merged through 'id stitching' keys. By accessing the id_changes table within a specific parent segment's database, the skill can reconstruct profile histories, identify merged RIDs, and quantify profile changes over specific time intervals. This provides critical visibility into the internal workings of the Customer Data Platform (CDP) identity graph, helping users debug profile merging logic and audit data ingestion patterns.

주요 기능

Extract and map key-value pairs from current_id_attributes JSON arrays
Track identity stitching events to audit profile merges and deletions
Automate time-based filtering using TD_INTERVAL for specific audit windows
Reconstruct profile history by tracing merged RIDs and initial creation logs
2 GitHub stars
Query the id_changes log for real-time profile creation and updates

사용 사례

Tracing the lifecycle and attribute history of a specific Real-time ID (RID)
Investigating why specific customer profiles were merged or kept separate in the CDP
Auditing the volume of new profile creations and deletions over the last 24 hours

소개

주요 기능

Extract and map key-value pairs from current_id_attributes JSON arrays
Track identity stitching events to audit profile merges and deletions
Automate time-based filtering using TD_INTERVAL for specific audit windows
Reconstruct profile history by tracing merged RIDs and initial creation logs
2 GitHub stars
Query the id_changes log for real-time profile creation and updates

사용 사례

Tracing the lifecycle and attribute history of a specific Real-time ID (RID)
Investigating why specific customer profiles were merged or kept separate in the CDP
Auditing the volume of new profile creations and deletions over the last 24 hours