IsUnique - Amazon Glue
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

IsUnique

Checks whether all of the values in a column are unique, and returns a Boolean value.

Syntax

IsUnique <COL_NAME>
  • COL_NAME – The name of the column that you want to evaluate the data quality rule against.

    Supported column types: Any column type

Example: Unique column values

The following example rule checks whether all of the values in a column named email are unique.

IsUnique "email" IsUnique "Customer_ID" where "Customer_ID < 10"]