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.

Language: English