ARRAY_CONTAINS returns a Boolean indicating whether the array contains the specified value. You can check for a partial or full match of an object by using a boolean expression within the command. Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/sql-query-array-contains