Identifier Linking via SQL

Overview

Identifiers can be linked directly in SQL. This is useful when when you have a real-time identifier match in a SQL process or when back-filling data.

A user must be assigned of the following application roles to execute any of the examples described on this page:

To link two identifiers, simply make a stored procudure call. Note that the referenced Subject Types must exist already.

SELECT experimentation.link_identifiers('<Subject Type A>', '<Subject ID A>', '<Subject Type B>', '<Subject ID B>');

SELECT experimentation.link_identifiers('CUSTOMER_ID', 'u_123', 'ANON_ID', 'a_123');