## Example query to get 1 Profile with all the edges ```cypher MATCH (p:Profile {profileType: 'LabelProfile'}) WHERE ANY(r IN p.roles WHERE r IN ['administrator', 'catalog']) MATCH (i:Identity)-[r1:HAS_PROFILE]-(p)-[r2:HAS_ACCESS_TO]-(v:Vendor) RETURN i, r1, p, r2, v limit 1; ``` # Topics ## Kafka topic: cdc.musicGraphV5.profile We'll read from the `cdc.musicGraphV5.profile` kafka topic. It contains changes for every profile ### Complete Event ```json { "id": "CMuchIK-Okrtvfug-fqLgHgAAAAAHyMwrwAAAAAAAAMlAAABnLXxjT8=", "txId": 522399919, "seq": 805, "metadata": { "authenticatedUser": "neo4j-cypher-scheduler", "executingUser": "neo4j-cypher-scheduler", "connectionType": "bolt", "connectionClient": "10.100.31.30:51234", "connectionServer": "10.100.121.96:7687", "serverId": "416b4e6d", "captureMode": "FULL", "txStartTime": { "type": "TZDT", "B": null, "I64": null, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": "2026-03-03T23:03:52.379Z", "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "txCommitTime": { "type": "TZDT", "B": null, "I64": null, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": "2026-03-03T23:03:52.383Z", "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "txMetadata": {} }, "event": { "elementId": "4:cb9c8482-be3a-4aed-bdfb-a0f9fa8b8078:896828368", "eventType": "NODE", "operation": "UPDATE", "labels": [ "Profile" ], "keys": { "Profile": [ { "profileType": { "type": "S", "B": null, "I64": null, "F64": null, "S": "MoneyhubProfile", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "profileId": { "type": "I64", "B": null, "I64": 627526, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "uuid": null }, { "profileType": null, "profileId": null, "uuid": { "type": "S", "B": null, "I64": null, "F64": null, "S": "0a449bc3-1d42-4118-8e5e-b800f3edb426", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null } } ] }, "state": { "before": { "labels": [ "Profile" ], "properties": { "profileName": { "type": "S", "B": null, "I64": null, "F64": null, "S": "Muhammet Vance", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "createdAt": { "type": "TZDT", "B": null, "I64": null, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": "2025-07-22T23:17:26.137Z", "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "updatedBy": { "type": "S", "B": null, "I64": null, "F64": null, "S": "ac857e75-ed6a-430e-8b2c-95dec0c48cbb", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "profileType": { "type": "S", "B": null, "I64": null, "F64": null, "S": "MoneyhubProfile", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "profileId": { "type": "I64", "B": null, "I64": 627526, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "roles": { "type": "LS", "B": null, "I64": null, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": [ "accounting" ], "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "updatedOn": { "type": "TZDT", "B": null, "I64": null, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": "2025-07-22T23:17:26.137Z", "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "brand": { "type": "S", "B": null, "I64": null, "F64": null, "S": "theorchard", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "uuid": { "type": "S", "B": null, "I64": null, "F64": null, "S": "0a449bc3-1d42-4118-8e5e-b800f3edb426", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null } } }, "after": { "labels": [ "Profile" ], "properties": { "profileName": { "type": "S", "B": null, "I64": null, "F64": null, "S": "Muhammet Vance", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "createdAt": { "type": "TZDT", "B": null, "I64": null, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": "2025-07-22T23:17:26.137Z", "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "updatedBy": { "type": "S", "B": null, "I64": null, "F64": null, "S": "ac857e75-ed6a-430e-8b2c-95dec0c48cbb", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "profileType": { "type": "S", "B": null, "I64": null, "F64": null, "S": "MoneyhubProfile", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "profileId": { "type": "I64", "B": null, "I64": 627526, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "fullCatalogAccess": { "type": "B", "B": false, "I64": null, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "roles": { "type": "LS", "B": null, "I64": null, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": [ "accounting" ], "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "updatedOn": { "type": "TZDT", "B": null, "I64": null, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": "2025-07-22T23:17:26.137Z", "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "brand": { "type": "S", "B": null, "I64": null, "F64": null, "S": "theorchard", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "uuid": { "type": "S", "B": null, "I64": null, "F64": null, "S": "0a449bc3-1d42-4118-8e5e-b800f3edb426", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null } } } } } } ``` ## cdc.musicGraphV5.hasProfile CDC with every :HAS_PROFILE relationship. ### Example event ```json { "id": "CLC6lHiW_krglAp6DWDsFCIAAAAAHrQF1gAAAAAAAAAFAAABnKuiXts=", "txId": 515114454, "seq": 5, "metadata": { "authenticatedUser": "neo4j-cypher-scheduler", "executingUser": "neo4j-cypher-scheduler", "connectionType": "bolt", "connectionClient": "10.100.30.142:34448", "connectionServer": "10.100.121.96:7687", "serverId": "416b4e6d", "captureMode": "FULL", "txStartTime": { "type": "TZDT", "B": null, "I64": null, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": "2026-03-01T23:01:10.881Z", "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "txCommitTime": { "type": "TZDT", "B": null, "I64": null, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": "2026-03-01T23:01:11.003Z", "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "txMetadata": {} }, "event": { "elementId": "5:b0ba9478-96fe-4ae0-940a-7a0d60ec1422:6917556515508038367", "eventType": "RELATIONSHIP", "operation": "CREATE", "type": "HAS_PROFILE", "start": { "elementId": "4:b0ba9478-96fe-4ae0-940a-7a0d60ec1422:96744024", "labels": [ "Identity" ], "keys": { "Identity": [ { "id": { "type": "S", "B": null, "I64": null, "F64": null, "S": "71dae95d-7555-44e8-860b-856b815ced3b", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null } } ] } }, "end": { "elementId": "4:b0ba9478-96fe-4ae0-940a-7a0d60ec1422:76262111", "labels": [ "Profile" ], "keys": { "Profile": [ { "profileType": { "type": "S", "B": null, "I64": null, "F64": null, "S": "ArtistProfile", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "profileId": { "type": "I64", "B": null, "I64": 1346777, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "uuid": null }, { "profileType": null, "profileId": null, "uuid": { "type": "S", "B": null, "I64": null, "F64": null, "S": "dc430a20-0051-4e69-9b96-3dd8618bcea7", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null } } ] } }, "keys": [], "state": { "before": null, "after": { "properties": {} } } } } ``` ## cdc.musicGraphV5.deletedHasProfile https://qa-akhq.theorchard.io/ui/qa-cdc/topic/cdc.musicGraphV5.deletedHasProfile/data?sort=Oldest&partition=All ```json { "id": "CMuchIK-Okrtvfug-fqLgHgAAAAAHyM0JgAAAAAAAAAAAAABnLgxWlo=", "txId": 522400806, "seq": 0, "metadata": { "authenticatedUser": "ows-users", "executingUser": "ows-users", "connectionType": "bolt", "connectionClient": "10.100.122.215:35540", "connectionServer": "10.100.121.96:7687", "serverId": "416b4e6d", "captureMode": "FULL", "txStartTime": { "type": "TZDT", "B": null, "I64": null, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": "2026-03-04T09:32:48.052Z", "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "txCommitTime": { "type": "TZDT", "B": null, "I64": null, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": "2026-03-04T09:32:48.09Z", "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "txMetadata": {} }, "event": { "elementId": "5:cb9c8482-be3a-4aed-bdfb-a0f9fa8b8078:1152996272353952758", "eventType": "RELATIONSHIP", "operation": "CREATE", "type": "DELETED_HAS_PROFILE", "start": { "elementId": "4:cb9c8482-be3a-4aed-bdfb-a0f9fa8b8078:956417014", "labels": [ "Identity" ], "keys": { "Identity": [ { "id": { "type": "S", "B": null, "I64": null, "F64": null, "S": "ef25057e-0214-4f04-9d7c-58bc63d7f590", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null } } ] } }, "end": { "elementId": "4:cb9c8482-be3a-4aed-bdfb-a0f9fa8b8078:956417057", "labels": [ "Profile" ], "keys": { "Profile": [ { "profileType": { "type": "S", "B": null, "I64": null, "F64": null, "S": "InsightsProfile", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "profileId": { "type": "I64", "B": null, "I64": 37909991234, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null }, "uuid": null }, { "profileType": null, "profileId": null, "uuid": { "type": "S", "B": null, "I64": null, "F64": null, "S": "0ef3f9c8-919c-421f-aad3-0d6016fe91a3", "BA": null, "TLD": null, "TLDT": null, "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null } } ] } }, "keys": [], "state": { "before": null, "after": { "properties": { "dateDeleted": { "type": "TLDT", "B": null, "I64": null, "F64": null, "S": null, "BA": null, "TLD": null, "TLDT": "2026-03-04T09:32:48.052", "TLT": null, "TZDT": null, "TOT": null, "TD": null, "SP": null, "LB": null, "LI64": null, "LF64": null, "LS": null, "LTLD": null, "LTLDT": null, "LTLT": null, "LZDT": null, "LTOT": null, "LTD": null, "LSP": null } } } } } } ```