title: How do I delete all rows of a database table using NiFi Processor?
body: <p>I have a need to delete all records in a Postgres DB table before running a NiFi flow.
  I would like to make this emptying of the table also a part of the NiFi flow.</p>
  <p>What is the right processor to use ?  I looked into PutDatabaseRecord and it appears that some combination of &quot;Statement Type&quot;  and &quot;Field Containing SQL&quot; will do the trick.</p>
  <p>Do you have an example?<br />
  Is there a better way to do this using a different processor?</p>
  <p>Thanks for your help.</p>