Using only AWS infracode, is it possible for a stream of events to trigger updates and deletions of existing matched records in a table or database?
In other words, are components like EventBridge, Glue, Step Functions, Kinesis Firehose, etc (but excluding Lambdas or server-run code) able to selectively enact a modification or removal of an existing record in some kind of managed database table (like an S3 Table, or RDS or DynamoDB)?
There seems to be a common pattern of using these components to only append (or insert) a new record (in some table or database) for each event, resulting in a table that only ever grows larger. For my application I want the event handling to sometimes instead modify or remove an existing record. Is this possible using just infracode and no lambdas?