Leagues dataset

Private leagues by project

Stores details of all private leagues created by users in a Project.

Table name: customer_schema.silver_leagues

Data source: Monterosa Gamify

Update method: Batch

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]
league_id	string	Unique League identifier	[uuid]
league_name	string	Name given by league owner	A league of their own
owner_id	string	Monterosa user ID of league owner	[uuid]
owner_external_id	string	SSO ID of league owner
member_ids	array(string)	Monterosa user IDs of league members	[[uuid],[uuid]]
member_external_ids	arrary(string)	SSO IDs of league members	[xxxx,yyyy]

Sample CSV data:

project_id,league_id,league_name,owner_id,owner_external_id,member_ids,member_external_ids
"e6f40e27-09cc-4e53-91b0-7836a8f4a63a","2a1cc89d-2456-4e8b-99e1-95671a1ecfa3","Fantastic Football League","54e6c02c-8d6b-42a5-a8b4-2f1ae7d9d1a9",987654321,"[a1b2c3d4-e5f6-4a8b-9c10-123456789abc, d5e6f7a8-b9c0-41a2-8304-abcdefghijk, 09876543-21dc-4b6e-9fa0-lkjihgfedcba]","[123456789, 987654321, 456789012]"
"7e93b56d-fb8a-4b1c-9cde-96a8b5cfda7b","9b6df289-86f8-4f1d-bc98-15436c872a63","Super Soccer League","683ecde1-98f2-49e3-ae9d-c7d2a98b9654",456789012,"[11111111-2222-3333-4444-555555555555, 66666666-7777-8888-9999-000000000000, 12345678-9876-5432-1098-abcdefabcdef]","[234567890, 345678901, 567890123]"
"4d35b84c-8a0a-45a8-9fe7-dc4eb63abdc4","ec0b3a5b-78f0-4fd9-a3d3-6c8c352951d1","Mega Football Club","b0a4d36a-7322-4784-96e3-1b1fe4f5a6d0",123456789,"[aaaabbbb-cccc-dddd-eeee-ffff00001111, 2222aaaa-bbbb-cccc-dddd-eeee00001111, 11112222-3333-4444-5555-666600001111]","[678901234, 789012345, 890123456]"
"8cf4396b-1b8b-4fe3-92d4-3e6c18a87fcf","e1c2ef11-d224-4f09-a6c4-87f0760d8b8b","Ultimate Kick League","d7e8f9a0-1b2c-4d5e-6f7a-8b9c0d1e2f3a",234567890,"[98765432-10dc-ba98-7654-3210fedcba98, abcdef01-2345-6789-0123-4567fedcba98, 54321098-fedc-ba09-8765-4321abcdef01]","[901234567, 123456789, 234567890]"
"6cf843e7-07f7-4cb3-9b7c-3a6f2219a480","5cdef5d7-9b11-4e4f-8019-c7f3b29bf53d","Dream Team Soccer","8d9e0f1a-2b3c-4d5e-6f7a-8b9c0d1e2f3a",789012345,"[12345678-9876-5432-1098-abcdefabcdef, aaaabbbb-cccc-dddd-eeee-ffff00001111, 11112222-3333-4444-5555-666600001111]","[345678901, 456789012, 567890123]"

Sample JSON data:

[
  {
    "project_id": "e6f40e27-09cc-4e53-91b0-7836a8f4a63a",
    "league_id": "2a1cc89d-2456-4e8b-99e1-95671a1ecfa3",
    "league_name": "Fantastic Football League",
    "owner_id": "54e6c02c-8d6b-42a5-a8b4-2f1ae7d9d1a9",
    "owner_external_id": "987654321",
    "member_ids": [
      "a1b2c3d4-e5f6-4a8b-9c10-123456789abc",
      "d5e6f7a8-b9c0-41a2-8304-abcdefghijk",
      "09876543-21dc-4b6e-9fa0-lkjihgfedcba"
    ],
    "member_external_ids": ["123456789", "987654321", "456789012"]
  },
  {
    "project_id": "7e93b56d-fb8a-4b1c-9cde-96a8b5cfda7b",
    "league_id": "9b6df289-86f8-4f1d-bc98-15436c872a63",
    "league_name": "Super Soccer League",
    "owner_id": "683ecde1-98f2-49e3-ae9d-c7d2a98b9654",
    "owner_external_id": "456789012",
    "member_ids": [
      "11111111-2222-3333-4444-555555555555",
      "66666666-7777-8888-9999-000000000000",
      "12345678-9876-5432-1098-abcdefabcdef"
    ],
    "member_external_ids": ["234567890", "345678901", "567890123"]
  },
  {
    "project_id": "4d35b84c-8a0a-45a8-9fe7-dc4eb63abdc4",
    "league_id": "ec0b3a5b-78f0-4fd9-a3d3-6c8c352951d1",
    "league_name": "Mega Football Club",
    "owner_id": "b0a4d36a-7322-4784-96e3-1b1fe4f5a6d0",
    "owner_external_id": "123456789",
    "member_ids": [
      "aaaabbbb-cccc-dddd-eeee-ffff00001111",
      "2222aaaa-bbbb-cccc-dddd-eeee00001111",
      "11112222-3333-4444-5555-666600001111"
    ],
    "member_external_ids": ["678901234", "789012345", "890123456"]
  },
  {
    "project_id": "8cf4396b-1b8b-4fe3-92d4-3e6c18a87fcf",
    "league_id": "e1c2ef11-d224-4f09-a6c4-87f0760d8b8b",
    "league_name": "Ultimate Kick League",
    "owner_id": "d7e8f9a0-1b2c-4d5e-6f7a-8b9c0d1e2f3a",
    "owner_external_id": "234567890",
    "member_ids": [
      "98765432-10dc-ba98-7654-3210fedcba98",
      "abcdef01-2345-6789-0123-4567fedcba98",
      "54321098-fedc-ba09-8765-4321abcdef01"
    ],
    "member_external_ids": ["901234567", "123456789", "234567890"]
  },
  {
    "project_id": "6cf843e7-07f7-4cb3-9b7c-3a6f2219a480",
    "league_id": "5cdef5d7-9b11-4e4f-8019-c7f3b29bf53d",
    "league_name": "Dream Team Soccer",
    "owner_id": "8d9e0f1a-2b3c-4d5e-6f7a-8b9c0d1e2f3a",
    "owner_external_id": "789012345",
    "member_ids": [
      "12345678-9876-5432-1098-abcdefabcdef",
      "aaaabbbb-cccc-dddd-eeee-ffff00001111",
      "11112222-3333-4444-5555-666600001111"
    ],
    "member_external_ids": ["345678901", "456789012", "567890123"]
  }
]