Is it possible to delete rows from the table you are loading data from? Example: We load data from Postgres database with RDS query component and would like to delete all the rows in the table after the rows are loaded

Matillion ETL
1

Is it possible to delete rows from the table you are loading data from? Example: We load data from Postgres database with RDS query component and would like to delete all the rows in the table after the rows are loaded.

2

Not possible in Matillion Components in apply the commands in Source dB's. But you can write the python script and achieve this.