Step 3 - Create a distinct list of user ids and prospect ids

In this step we will create a driver table with a distinct list of prospect ids and user ids for subsequent processing

NOTE: Ensure you copy the #standardSQL a the top of the query so that it ensures the correct engine is used

 #standardSQL
SELECT
  DISTINCT user_id,
  prospect_id
FROM
  [your-dataset-name].tmp_activity_8066_parsed
WHERE
  prospect_id IS NOT NULL
  AND user_id != '0'

Resulting Table: Using the “Save as Table” button in the query results pane, create:

Dataset: [your-dataset-name]

Table ID: dcm_identity_map