title: Event ingestion and query ability
body: <p>I need to put in place a system, in which I need to ingest a events (emails, page visits, page events, etc.) and at the same time I need to ensure I'm able to analyse and build reports on top of that data set. At this point I expect something under 100 events per second.</p>
  
  <p>I'll most likely use AWS services to implement this.</p>
  
  <p>Can you give me some suggestions on possible architectures for this.</p>
  
  <p>The first one I can think off is to have an API Gateway endpoint receiving the events, connected to a lambda expression that then inserts data into Redshift.</p>
  
  <p>Other alternative would be to use kinesis streams and load them directly to Redshift.</p>
  
  <p>If done like this will Redshift allow me to still querying the data in real time without having locking issues?</p>
  
  <p>What other alternatives can you suggest? I was also taking a look into Google Query.</p>
  
  <p>Thank you.</p>