title: Delete azure sql database rows from azure databricks
body: <p>I have a table in Azure SQL database from which I want to either delete selected rows based on some criteria or entire table from Azure Databricks. Currently I am using the <strong><em>truncate</em></strong> property of JDBC to truncate the entire table without dropping it and then re-write it with new dataframe.</p>
  
  <pre><code>df.write \
       .option('user', jdbcUsername) \
       .option('password', jdbcPassword) \
       .jdbc('&lt;connection_string&gt;', '&lt;table_name&gt;', mode = 'overwrite', properties = {'truncate' : 'true'} )
  </code></pre>
  
  <p>But going forward I don't want to truncate and overwrite the entire table every time but rather use delete command. I was not able to achieve this using <em>pushdown query</em> either. Any help on this would be greatly appreciated.</p>