Role in this project:
Back-end Developer & Database Engineer Contributions:86 commits, 10 PRs, 8 pushes in 5 months
Contributions summary:Edward primarily contributed to the Snowplow project by adding Redshift DDL (Data Definition Language) scripts. These scripts define the structure of tables within a Redshift database, specifically for storing data related to Urban Airship Connect events. The commits focused on creating schemas and tables for various event types, including CLOSE, FIRST_OPEN, IN_APP_MESSAGE_EXPIRATION, LOCATION, OPEN, IN_APP_MESSAGE_RESOLUTION, IN_APP_MESSAGE_DISPLAY, CUSTOM, TAG_CHANGE, RICH_READ, UNINSTALL, SEND, RICH_DELETE, PUSH_BODY, RICH_DELIVERY, and REGION. The work demonstrates a focus on data modeling and database schema design for event data.