Batch v real time enrichment

Snowplow is flexible to a certain extend. You can build it in various ways. It is ambiguous when you say current snowplow.

It is impossible to do so by the sheer nature of the two architectures. The real-time pipeline is for real-time processing while the batch pipeline is for batch processing.

You can combine the two by building so-called Lambda architecture. The data will be available in (near) real time, yet you still can shred it and load into Redshift (batch pipeline) if required.