Question
In Twilio Segment Engage, can SQL Traits be configured to update existing profiles only and avoid creating new profiles when no matching user exists?
Product
Twilio Segment
Environment
Segment Console
Answer
No. SQL Traits cannot currently be configured as “update only.”
When a SQL Trait returns data for an identifier that does not match an existing profile, Engage can create a new profile by generating an internal identify event. This behavior is expected.
To prevent unwanted profiles from being recreated, update the SQL Trait query so it excludes users that should not be added or updated, such as deleted, suppressed, or pending-deletion users.
Additional Information
Internal identify events generated by Engage not appear in the source debugger.
If a deleted user’s data still exists in the connected warehouse, a SQL Trait can return that user again and recreate the profile. Ensure deletion or suppression logic is also reflected in the SQL Trait source data or query.