Users dataset

Users by Project

Stores identity data relating to users that have signed in to Identify, including SSO ID for registered users and display name in leaderboards where relevant

Table name: customer_schema.silver_users

Data source: Monterosa Identify

Update method: Batch or stream

Update frequency: TBD

See Monterosa Identifiers for details of the IDs used in this dataset

Column	Type	Description	Example
project_id	string	Unique project identifier	[uuid]
user_id	string	Monterosa user ID	[uuid]
external_id	string	SSO user ID
display_name	string	username for leaderboards if relevant	jd12345

Sample CSV data:

"project_id","user_id","external_id","display_name"
"3e5f63c1-2b8f-4f28-b2e4-0a3097c6c153","23b879d4-7e90-4683-a889-8e9f7eaf9e23","123456789","Alice"
"45c3a076-2643-4a2b-9c02-9f67b9e5c18d","b920c1a2-e642-49ac-85f8-1f3e7e62f0b7","987654321","Bob"
"88a7d5ed-9833-47b9-8667-1d14c1e864c4","a76d8d6e-3b44-4e1a-8ac5-06e1ad46595f","246813579","Charlie"
"4c4ce4b3-589a-49d3-8966-2f57b4a41c2a","1c48799b-3e85-4e4b-a25a-d87b81f8bc1d","135792468","David"
"feb18ef4-2c7c-498f-86ab-86ed564b7c1e","c5487e14-7f4d-4e1d-8f32-5c61e0e4fcd7","314159265","Eve"

SAmple JSON data:

[
  {
    "project_id": "3e5f63c1-2b8f-4f28-b2e4-0a3097c6c153",
    "user_id": "23b879d4-7e90-4683-a889-8e9f7eaf9e23",
    "external_id": "123456789",
    "display_name": "Alice"
  },
  {
    "project_id": "45c3a076-2643-4a2b-9c02-9f67b9e5c18d",
    "user_id": "b920c1a2-e642-49ac-85f8-1f3e7e62f0b7",
    "external_id": "987654321",
    "display_name": "Bob"
  },
  {
    "project_id": "88a7d5ed-9833-47b9-8667-1d14c1e864c4",
    "user_id": "a76d8d6e-3b44-4e1a-8ac5-06e1ad46595f",
    "external_id": "246813579",
    "display_name": "Charlie"
  },
  {
    "project_id": "4c4ce4b3-589a-49d3-8966-2f57b4a41c2a",
    "user_id": "1c48799b-3e85-4e4b-a25a-d87b81f8bc1d",
    "external_id": "135792468",
    "display_name": "David"
  },
  {
    "project_id": "feb18ef4-2c7c-498f-86ab-86ed564b7c1e",
    "user_id": "c5487e14-7f4d-4e1d-8f32-5c61e0e4fcd7",
    "external_id": "314159265",
    "display_name": "Eve"
  }
]