ARRAY_CONTAINS

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Checks whether a specified value is present in an array.

1ARRAY_CONTAINS(<array>, <value>)

• <array>: The array to search.
• <value>: The search value.

Returns a boolean value (true or false) that indicates whether the value is present in the array.

• The value must match the element type of the array.
• Comparison is exact and case-sensitive for strings.

Check whether a value exists in an array.

1SELECT array_contains(array[1, 3, 4], 3) AS contains_three;

Returns true because 3 is present in the array.

Check whether a value is present in an array.

1SELECT array_contains(array[1, 3, 4], 2) AS contains_two;

Returns false because 2 isn’t present in the array.

• Array Data Type