SendGrid+Snowplow+AWS S3&Redshift

Hi @AllenWeieiei,

The next component you need is Stream Enrich that validates raw data and transforms it into a canonical TSV format. However this also isn’t the end if you also want to load data into Redshift because you’ll need RDB Loader and optionally EmrEtlRunner to orchestrate it.

What you want to have is so called Lambda Architecture, you can read more in its dedicated article: