Purge Data from Tables?

[mrossPM2]

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.

[JoeM]

@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. 

[JoeM · Accepted solution]

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