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] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.3.0/src/snowflake/snowpark/functions.py#L2570-L2580)¶

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.