Preserving an Audit Trail of Events

This solution describes how to design a pipeline that preserves an audit trail of pipeline and stage events that occur.

Store event records to preserve an audit trail of the events that occur. You can store event records from any event-generating stage.

For this solution, say you want to keep a log of the objects written to Amazon S3 by the following pipeline:

To do this, you simply:
  1. Configure the Amazon S3 destination to generate events.

    On the General tab, select the Produce Events property

    Now the event output stream becomes available, and the destination generates an event each time it completes writing to an object. For this destination, each event record includes fields for the bucket the object is written to, the object key name, and number of records written to the object.

  2. You can write the event records to any destination, but let's assume you want to write them to Amazon S3 as well:

    You could be done right there, but you want to include the time of the event in the record, so you know exactly when the Amazon S3 destination completes writing to the object.

  3. All event records include the event creation time in the sdc.event.creation_timestamp record header attribute, so you can add an Expression Evaluator to the pipeline and use the following expression to include the creation time in the record:

    The resulting pipeline looks like this:

    Note that event creation time is expressed as an epoch or Unix timestamp, such as 1477698601031. And record header attributes provide data as strings.

    Tip: You can use time functions to convert timestamps to different data types. For more information, see Functions.