Solution Components - Digital User Engagement Events Database

Solution Components

Amazon Athena database

The deployed Amazon Athena database contains all engagement data from Amazon Pinpoint and Amazon Simple Email Service (Amazon SES) configuration sets. A single table is constructed that matches the event schema from the Amazon Pinpoint event stream. Individual views are created for each event type, which allows the data to be easily consumed by end users.

Refer to the full data dictionary that describes each view at the field level in Appendix A. Customers can use the Amazon Pinpoint Events API to report custom events from their applications. To create views for these custom events, refer to Appendix E. Reference queries using these views can be found in Appendix B, which demonstrates query best practices including how to use the partition field ingest_timestamp.

Amazon Kinesis Data Firehose

This solution deploys a single reusable Amazon Kinesis Data Firehose and configures it to be used by the Amazon Pinpoint project’s event stream. This Kinesis Data Firehose can be used in multiple Amazon SES configuration sets and Amazon Pinpoint projects at the same time.

To configure additional Amazon Pinpoint projects, refer to Appendix C. To configure additional Amazon Simple Email Service configuration sets, refer to Appendix D.