title: Is it possible to use a dynamic array/list as input for parameterizing a kusto query?
body: <p>I have an application that uses the Python library azure.kusto.data to query data from a Kusto cluster. I'm wondering, is it possible to use a dynamic array as input for paramterizing a kusto query?</p>
  <p>The existing documentation doesn't seem to call out such functionality.
  <a href="https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/queryparametersstatement?pivots=azuredataexplorer" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/queryparametersstatement?pivots=azuredataexplorer</a></p>
  <p>Passing in string type values has worked fine in the past:</p>
  <pre><code>    params = {
          &quot;scenario&quot;: &quot;string&quot;,
          &quot;env&quot;: &quot;string2&quot;,
          &quot;duration&quot;: &quot;string3&quot;,
      }
  
      query = &quot;&quot;&quot;
      declare query_parameters(scenario:string, env:string, duration:string);
      Some_Kusto_Query(scenario, env, duration)
      &quot;&quot;&quot;
  </code></pre>
  <p>I will then pass the dictionary and query string into the Kusto library to get the data I need. This works fine. What does not work fine is whenever I try some version of this:</p>
  <pre><code>    params = {
          &quot;scenario&quot;: &quot;string&quot;,
          &quot;env&quot;: &quot;string2&quot;,
          &quot;duration&quot;: &quot;string3&quot;,
          &quot;value_list&quot;: [1,2,3,4]
      }
  
      query = &quot;&quot;&quot;
      declare query_parameters(scenario:string, env:string, duration:string, value_list:dynamic);
      Some_Kusto_Query(scenario, env, duration)
          | where value in value_list
      &quot;&quot;&quot;
  </code></pre>
  <p>I've tried many different iterations of this and can't seem to get it to work. The only other idea I have at this point would be to pass in value_list as a delimited string (e.g., &quot;1-2-3-4&quot;) and use the split() function in kusto to deserialize the string back to an array, but this doesn't seem ideal.</p>
  <p>Any tips or pointers would be appreciated - I've scoured the Kusto docs/Google and haven't come across any good examples online.</p>
  <p>Thanks!</p>