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

snowflake.snowpark.functions.arrays_overlap¶

snowflake.snowpark.functions.arrays_overlap(array1: ColumnOrName, array2: ColumnOrName) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.3.0/src/snowflake/snowpark/functions.py#L2561-L2567)¶: Compares whether two ARRAYs have at least one element in common. Returns TRUE if there is at least one element in common; otherwise returns FALSE. The function is NULL-safe, meaning it treats NULLs as known values for comparing equality.