I was able to delete specific rows from a base view by creating a scheduler job as a Parameterized query.
1. In the Parameterized query field of Extraction section, you can issue the below statement example:
DELETE FROM <view_name> WHERE <column_name> = ‘@column_name’
2. In the Non-Parameterized query section, you can issue the below statement example to retrieve specific rows that need to be deleted:
SELECT * FROM <view_name> WHERE <column_name> = ‘condition’
3. Create the mapping on the job to map your column from the Non-parameterized query with the parameter in the Parameterized query.
Query: <column_name> = source: <coulmn_name>
You can run the job to delete specific rows specified in the Select statement condition.
You can read more about creating Parameterized queries in the [VDP Extraction](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/vdp_extraction_section) Section of Scheduler Administration Guide.
Hope this helps!