topic Purge Data from Tables? in Data & Schema Discussions

Purge Data from Tables?

mrossPM2 — Mon, 07 Oct 2024 19:00:25 GMT

Is there a straightforward way to purge data from tables? We loaded data into several schemas from a Data Application, but we don't need all of the data for our current reporting requirements. Is there a way to keep the tables, but purge the data within them?

My thought for a workaround would be to add a filter to the extraction SQL (WHERE 1=2) and then run a full load, but I wanted to check if there's a built-in feature within Incorta to accomplish the same thing. If no such feature exists, you can consider this a feature request.

Re: Purge Data from Tables?

JoeM — Mon, 07 Oct 2024 19:17:45 GMT

@mrossPM2 - In 2024.7.1, we are introducing the ability to purge data through the interface without invoking a full load. There will be a new 'action' on the load menu to purge data based on logic set in the table's advanced settings. Until then, performing the full load that will return empty logic is a fair workaround.

Re: Purge Data from Tables?

JoeM — Thu, 31 Oct 2024 16:38:46 GMT

@mrossPM2 - Just letting you know it's now available starting 2024.7.1!