uuid in Merge

William_Scardua
Valued Contributor

Hi guys,

I'm trying to use uuid in the merge but I always get an error...

import uuid
 
(
  df_events.alias("events").merge(
    source = df_updates.alias("updates"),
    condition = "events.cod = updates.cod and events.num = updates.num"
  ).whenMatchedUpdate(
    set =
      {
      "events.cod" : "updates.cod",
      "events.num_c" : "updates.num_contrato",
      "events.status": lit("Updated")"
      }
  ).whenNotMatchedInsert(values =
    {
      "events.id" : uuid.uuid4(),
      "events.cod" : "updates.cod",
      "events.num" : "updates.num",
      "events.status" : lit("Inserted")
    }
  )
  .execute()
)

have any tips ?