title: SOQL Select all columns in Azure Data Factory (Incremental Load from Salesforce)
body: <p>Azure Data Factory gives an option to load data incrementally by using an SOQL query, Example bellow:</p>
  <pre><code>Select COLUMN_1,...,COLUMN_N from Account Where COLUMN_X = 'VALUES_X'
  </code></pre>
  <p>There is another solution: <strong>Delta copy from a database with a control table</strong>; but it is dedicated to Azure SQL Database and doesn't take into consideration other Data Sources like Salesforce:
  <a href="https://docs.microsoft.com/en-us/azure/data-factory/solution-template-delta-copy-with-control-table" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/azure/data-factory/solution-template-delta-copy-with-control-table</a></p>
  <p>Thus, we always have to use an SOQL query. The problem with it, is that we can't do a <strong>SELECT ALL</strong> as in SQL, example bellow:</p>
  <pre><code>Select * from Account
  </code></pre>
  <p>So we have to write manually tens of columns for multiple tables!</p>
  <p>Is there any way to launch an SOQL query from a <strong>Copy Data Activity</strong> in <strong>Azure Data Factory</strong> without mentioning all the columns?</p>
  <p>Best regards,</p>