Skip to main content
Skip table of contents

In my database I find DPV_?? Tables. Can I remove these?

Situation

I have a database where I run my anonymization project in.

When I look in that database I find several tables named DPV_<SHORTNUMBER>_<LONGNUMBER> i.e.: DPV_1_131752626656834354

Can I remove these tables?

Explanation

During the anonymization process Privacy creates and fills temporary tables. These contain the raw data at various levels, and are used to create and preselect the eventual anonymous data. Normally, these tables are removed during the clean-up stage of a run near its end, but if Privacy doesn't reach this point because a run was aborted the tables may remain. This is not a cause for concern. You can use these tables to check where in the process Privacy has encountered an error, or to restore the data to the test database. If a new run is started, these tables will be cleaned up. 


So the answer is:

NO: you cannot remove these tables during an anonymization run, they are required for the anonymization process.

NO: you cannot remove these tables if an error occurred and you want to analyze the error using the data in the tables.

YES: If Privacy has encountered an error which has resulted in you having to abort a run, you can delete these tables safely. 


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.