Sync Sendgrid data into Redshift with Jitsu
Jitsu.Cloud is the easiest way to try out Jitsu. Pricing is volume based
Jitsu Open-Source edition is free and can be deployed with any infrastructure provider
About Sendgrid integration
The Sendgrid source syncs campaigns and lists streams. There are two different kinds of marketing campaigns, "legacy marketing campaigns" and "new marketing campaigns". Only "new marketing campaigns" are supported.
RedShift is a fast and scalable data warehouse provided by AWS. Jitsu can send data to RedShift in both stream, and batch mode. For batch mode you'll need to provide access to S3 bucket where Jitsu will store temporary data batches.