Version:

IDs

Learn how to map source ID to entities and ID types in your Profiles project.

  •   less than a minute  

The ids key specifies the list of all the identifiers present in the source table with their column names (or SQL expression) and id_type.

ids:
  - select: id-column
    type: id_type
    entity: entity_name
    to_default_stitcher: true/false
FieldDescription
select
Required		ID column name or SQL expression.
type
Required		id_type from the list of id_types in the entity section of pb_project.yaml.
entity
Required		Entity name.
to_default_stitcherDefault true- set to false to exclude from the default ID stitcher.

Example

# Basic example
ids:
    - select: "id"
      type: salesforce_id
      entity: user

# Use SQL function on ID column
ids:
    - select: lower(email_address)
      type: email
      entity: user

# Multiple IDs for an entity
ids:
    - select: lower(email_address)
      type: email
      entity: user
    - select: "username"
      type: user_name
      entity: user

# IDs for multiple entities
ids:
    - select: lower(email_address)
      type: email
      entity: user
    - select: "account_id"
      type: account_id
      entity: account

Questions? Contact us by email or on Slack