missing-primary-key (GN004)

Automatic fix is not available.

What it does

Checks for existence of primary keys.

Why not?

A primary key is a set of attributes which prevents duplicates and can uniquely identify a record.

If you don't have one, you cannot tell records apart and you create a burden for yourself by checking for duplicate records.

When should you?

Never for OLTP databases.

If you are doing analytics (OLAP) at scale, then primary keys may not be very useful.

Use instead:

Define a primary key.