spark-redshift-connector: combine saving to redshift with a delete query
<p>i would like to update Redshift periodically with <strong>spark-redshift-connector</strong> (scala).
Each update starts with a Delete operation.
(i am performing kind of an <strong>Upsert</strong> to Redshift) </p>

<p>Is there a way i can execute it with the library ?
Can it be with a transaction ?</p>

<p>Any advice will be much appreciated.</p>

<p>thanks,
Eran.</p>