title: How does array_contains work in Snowpark Python API
body: <p>I have the following DataFrame</p>
  <pre><code>----------
  |&quot;ARR&quot;   |
  ----------
  |[       |
  |  &quot;A&quot;,  |
  |  &quot;B&quot;,  |
  |  &quot;C&quot;   |
  |]       |
  ----------
  </code></pre>
  <p>Not I want to check whether a specific element is in ARR:</p>
  <p>This gives a Error (failed to execute query...):</p>
  <pre><code>df\
      .withColumn(&quot;contains_A&quot;,array_contains(&quot;A&quot;,col(&quot;ARR&quot;)))\
      .show()
  </code></pre>
  <p>same here</p>
  <pre><code>df\
      .withColumn(&quot;contains_A&quot;,array_contains(lit(&quot;A&quot;),col(&quot;ARR&quot;)))\
      .show()
  </code></pre>
  <p>and this gives FALSE</p>
  <pre><code>df\
      .withColumn(&quot;contains_A&quot;,array_contains(array_construct(lit(&quot;A&quot;)),col(&quot;ARR&quot;)))\
      .show()
  </code></pre>
  <p>How to do it?</p>