Identity Warehouse (Limited Availability)

The Engage Identity Warehouse allows customers to export all identifiers associated with any one user.

When enabled, customers see a source called Engage Identities <space_name>. This automatically synchronizes to warehouses in a customer’s workspace. To disable, use Selective Sync.

To query the underlying data, customers can query:

SELECT * FROM engage_<space_name>_identities.users_identities

The columns in the tables are:

Example Queries

To see all identifiers associated with a certain user, first look up the segment_id associated with the external_id_value. Then, query all external_id_value’s associated with the segment_id.

 with t1 AS
  (SELECT segment_id
   FROM engage_identities.users_identities
   WHERE external_id_value = 'jane.doe@example1.com')
SELECT u.segment_id, created_source, external_id_type, external_id_value
FROM engage_identities.users_identities u
JOIN t1 on u.segment_id = t1.segment_id