_uid

Owned by Fiona Sargeant (Unlicensed)
Last updated: Aug 31, 2023 by Zoe Baldwin
1 min read

PhixFlow cannot ensure unique values for a primary key where:

  • the name is UID but its data type is not integer
  • the name is not UID

If your data already has a unique attribute, you can use that as the primary key. For example, the Teacher table could have a National Insurance attribute, which would be unique to a teacher. In this case, you must set up your own processes to make sure that the records in a table all have unique values in the primary key.