Delete specific rows from a dataset

Hi all,

Currently have a dataset which is populated via code repository and is incremental.

Some rows have been loaded into this dataset and we would like to remove these rows as they should not in the dataset for confidentiality reasons.

How can one remove rows from the dataset based on the primary key ?
We don’t want to just filter them out in a pipeline as we’d prefer to completely remove the rows.

I was thinking of perhaps using the API, specify the dataset RID, branch, primary key and delete these rows, but so far have been unsuccessful.

Any ideas how to do this ? (not necessarily with the API)

Thanks !

https://community.palantir.com/t/deleting-files-in-historic-transactions-without-breaking-the-incremental/824/6

You can read this thread where I asked the same question. To me the proposed solution is not adequate for such a common requirement in Foundry.