You are viewing documentation about an older version (1.3.0). View latest version

snowflake.snowpark.functions.array_intersection

snowflake.snowpark.functions.array_intersection(array1: ColumnOrName, array2: ColumnOrName) Column[source]

Returns an array that contains the matching elements in the two input arrays.

The function is NULL-safe, meaning it treats NULLs as known values for comparing equality.

Parameters:
  • array1 – An ARRAY that contains elements to be compared.

  • array2 – An ARRAY that contains elements to be compared.