Deleting Local Table (File) Records
Delete records from a local table (File) and free up storage through housekeeping on obsolete or already processed data changes.
Prerequisites
-
Data Warehouse Data Integration (--U-E---) – The DW Integrator role template, for example, grants this privilege.
-
Data Warehouse Consumption (--U-E---) – The DW Modeler role template, for example, grants this privilege.
For more information, see Privileges and Permissions and Standard Roles Delivered with SAP Datasphere.
-
From the Data Builder, open your local table (file) in the Table Editor.
-
Select from the toolbar, .
-
Choose one of the 2 available options:
-
Delete All Records (Mark as Deleted): Records will not be physically deleted but marked as deleted and filtered out when accessing the active records of the local table. They will still consume storage, and they can still be processed by other apps that consume them.
-
Delete Previous Versions (Vacuum): You delete previous versions, which are older than the number of days you have specified. Records that meet your defined criteria will be permanently deleted. The default value is 7 days. The minimum authorized value is 7 so that records from the last 7 days cannot be deleted, and the maximum value is 999 days. In addition, only records that have been fully processed by all delta consumers (for example transformation flows) can be deleted. Note that, however, even if the data is deleted through a vacuum task, data is kept for another 14 days in the file space storage. As it is very likely that you will not be able to go back more than 30 days, we recommend that you do not enter a period longer than 30 days as a vacuum deletion criterion.For more information, see Create a File Space to Load Data in the Object Store
[Optional]. When you select one of these options, you can override the default Apache Spark Application Settings that were defined at space creation by your administrator:-
Use Default: The default application is the application selected in the table settings. If no default application is defined there, the application selected by an administrator during the file space creation is used.
-
Define New Setting for This Table: Select another Apache Spark Application that fits your needs.
-
-
Confirm with Delete to start the deletion task.