Using the MISSING function with PartiQL for DynamoDB
Returns TRUE if the item does not contain the attribute specified. Only equality and inequality operators can be used with this function.
Syntax
attributenameIS | IS NOT MISSING
Arguments
attributename-
(Required) The attribute name to look for.
Return type
bool
Examples
SELECT * FROM Music WHERE "Awards" is MISSING
