USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM 'https://qa-orcdbucket.s3.amazonaws.com/participants/stores/apple_music_identifiers.csv' AS data
CREATE (ami:AppleMusicParticipantIdentifiers {
  vendorId: toInteger(data.VENDOR_ID),
  subaccountId: toInteger(data.SUBACCOUNT_ID),
  name: data.ORCHARD_ARTIST_NAME,
  appleMusicId: toInteger(data.APPLE_ARTIST_ID)
});

CALL apoc.periodic.iterate(
    "MATCH (ami:AppleMusicParticipantIdentifiers) RETURN ami",
    "
        MATCH (lp:LabelParticipant {
            name: ami.name,
            vendorId: ami.vendorId,
            subaccountId: ami.subaccountId
        })
            SET lp.appleMusicId = ami.appleMusicId
    ",
    {batchSize:1000});