DELETERECORD()`¶

About DeleteRecord¶

Deletes a Record from a FeatureGroup in the OnlineStore. Feature Store supports both SoftDelete and HardDelete. For SoftDelete (default), feature columns are set to null and the record is no longer retrievable by GetRecord or BatchGetRecord. For HardDelete, the complete Record is removed from the OnlineStore. In both cases, Feature Store appends the deleted record marker to the OfflineStore. The deleted record marker is a record with the same RecordIdentifer as the original, but with is_deleted value set to True, EventTime set to the delete input EventTime, and other feature values set to null.

Note that the EventTime specified in DeleteRecord should be set later than the EventTime of the existing record in the OnlineStore for that RecordIdentifer. If it is not, the deletion does not occur:

For SoftDelete, the existing (not deleted) record remains in the OnlineStore, though the delete record marker is still written to the OfflineStore.
HardDelete returns EventTime: 400 ValidationException to indicate that the delete operation failed. No delete record marker is written to the OfflineStore.

When a record is deleted from the OnlineStore, the deleted record marker is appended to the OfflineStore. If you have the Iceberg table format enabled for your OfflineStore, you can remove all history of a record from the OfflineStore using Amazon Athena or Apache Spark. For information on how to hard delete a record from the OfflineStore with the Iceberg table format enabled, see Delete records from the offline store.

Method Signature¶

METHODS /AWS1/IF_SGF~DELETERECORD
  IMPORTING
    !IV_FEATUREGROUPNAME TYPE /AWS1/SGFFEATUREGROUPNAMEORARN OPTIONAL
    !IV_RECORDIDVALUEASSTRING TYPE /AWS1/SGFVALUEASSTRING OPTIONAL
    !IV_EVENTTIME TYPE /AWS1/SGFVALUEASSTRING OPTIONAL
    !IT_TARGETSTORES TYPE /AWS1/CL_SGFTARGETSTORES_W=>TT_TARGETSTORES OPTIONAL
    !IV_DELETIONMODE TYPE /AWS1/SGFDELETIONMODE OPTIONAL
  RAISING
    /AWS1/CX_SGFACCESSFORBIDDEN
    /AWS1/CX_SGFINTERNALFAILURE
    /AWS1/CX_SGFSERVICEUNAVAILABLE
    /AWS1/CX_SGFVALIDATIONERROR
    /AWS1/CX_SGFCLIENTEXC
    /AWS1/CX_SGFSERVEREXC
    /AWS1/CX_RT_TECHNICAL_GENERIC
    /AWS1/CX_RT_SERVICE_GENERIC.

IMPORTING¶

Required arguments:¶

`iv_featuregroupname` `TYPE /AWS1/SGFFEATUREGROUPNAMEORARN` `/AWS1/SGFFEATUREGROUPNAMEORARN`¶

The name or Amazon Resource Name (ARN) of the feature group to delete the record from.

`iv_recordidvalueasstring` `TYPE /AWS1/SGFVALUEASSTRING` `/AWS1/SGFVALUEASSTRING`¶

The value for the RecordIdentifier that uniquely identifies the record, in string format.

`iv_eventtime` `TYPE /AWS1/SGFVALUEASSTRING` `/AWS1/SGFVALUEASSTRING`¶

Timestamp indicating when the deletion event occurred. EventTime can be used to query data at a certain point in time.

Optional arguments:¶

`it_targetstores` `TYPE /AWS1/CL_SGFTARGETSTORES_W=>TT_TARGETSTORES` `TT_TARGETSTORES`¶

A list of stores from which you're deleting the record. By default, Feature Store deletes the record from all of the stores that you're using for the FeatureGroup.

`iv_deletionmode` `TYPE /AWS1/SGFDELETIONMODE` `/AWS1/SGFDELETIONMODE`¶

The name of the deletion mode for deleting the record. By default, the deletion mode is set to SoftDelete.

Examples¶

Syntax Example¶

This is an example of the syntax for calling the method. It includes every possible argument and initializes every possible value. The data provided is not necessarily semantically accurate (for example the value "string" may be provided for something that is intended to be an instance ID, or in some cases two arguments may be mutually exclusive). The syntax shows the ABAP syntax for creating the various data structures.

lo_client->deleterecord(
  it_targetstores = VALUE /aws1/cl_sgftargetstores_w=>tt_targetstores(
    ( new /aws1/cl_sgftargetstores_w( |string| ) )
  )
  iv_deletionmode = |string|
  iv_eventtime = |string|
  iv_featuregroupname = |string|
  iv_recordidvalueasstring = |string|
).

/AWS1/IF_SGF=>DELETERECORD()¶