title: Azure Data Factory Recursive Query in source option
body: <p>I'm trying to execute a recursive query in Azure Data Factory Source using the query option.</p>
  <p><a href="https://i.stack.imgur.com/5HnUx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5HnUx.png" alt="enter image description here" /></a></p>
  <p>However, even writting <strong>go</strong> or <strong>;</strong> before the <strong>with</strong> sentence, Data Factory is not able to project the columns. If I write (before the with clause):</p>
  <ul>
  <li>&quot;Go&quot;, I've got this error <code>&quot;shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'r'. If this is intended to be a common table expression, you need to explicitly terminate the previous statement with a semi-colon.&quot;</code></li>
  <li>If I write &quot;;&quot;, I've got this one <code>shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ';'.</code></li>
  <li>If I do not write anything s<code>haded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'with'.</code></li>
  </ul>
  <p>So I wonder if this kind of code is not allowed in Azure Data Factory, or if there is something I'm missing.</p>