sendgrid-to-redshift

logs.classdojo.com

logs.classdojo.com is where web frontend logs are sent. To cheapen development costs, it was tacked onto an existing service called sendgrid-to-redshift, so it has some legacy sendgrid webhook functionality.

Sendgrid context

We want to get information about our email performance out of Sendgrid. Sendgrid sends the information to a webhook (a load balancer in front of two ec2 instances) which then streams it to the redshift analytics cluster.

Useful Links

• Build + Deploy
  • Deploy uses AWS CodeDeploy: see our Code-Deploy guide and the delivery repo
• Sendgrid web hook controls -- see "Event Notification" section
• sendgrid-to-redshift load balancer here
• Instances
• Firehose streams to the sendgrid table in the analytics cluster analytics database.
• Logs
• Metrics
  • sendgridToRedshift
  • Frontend errors
• To connect to the redshift table see the Campaign Manager repo and this guide. This sends metrics to the sendgrid table within the analytics database that lives in the analytics cluster.