@amitkhanal, as Alex pointed out you would have to shred the data before loading it to Redshift. In other words, run the EmrEtlRunner
with --skip staging,enrich
option thus leaving shred
task in place.
An alternative solution is to separate enrichment process for real-time and batch “branches” in Lambda architecture as per diagram in How to setup a Lambda architecture for Snowplow