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.
主要功能
01Extract and map key-value pairs from current_id_attributes JSON arrays
02Track identity stitching events to audit profile merges and deletions
03Automate time-based filtering using TD_INTERVAL for specific audit windows
04Reconstruct profile history by tracing merged RIDs and initial creation logs
052 GitHub stars
06Query the id_changes log for real-time profile creation and updates
使用场景
01Tracing the lifecycle and attribute history of a specific Real-time ID (RID)
02Investigating why specific customer profiles were merged or kept separate in the CDP
03Auditing the volume of new profile creations and deletions over the last 24 hours
