integrating redshift with sumologic

Follow

ravi jaladanki

• October 20, 2018 14:00

Hi all,

I need to query some tables in redshift to get the maximum date from a set of tables and display that dates in Sumologic. I am not able to find the straight forward way to connect to redshift from sumologic to query and get the data. Can any one help me in some documentation.

 

Thanks,

0

• 

  Graham Watts

  • October 22, 2018 00:52

  Hey Ravi,
  
  Seems like there are 2 options here:

  1. Collect the data in Sumo and query it there
     
     - Where is the data coming from? If its already in S3 or CloudWatch log groups you can use native Sumo sources to get a copy of the data into Sumo
     - If not, you could dump it to S3 and collect it into Sumo from there (AWS doc here) 
     
     
     
  2. Do not collect it into Sumo, instead query the data inside the Redshift table and send to Sumo
     
     - In this case you could potentially write a lambda function and use the GREATEST & LEAST Redshift function to get data and do a POST to our HTTPS source (endpoint) to collect it
     - Here is a example from StackOverflow that might help

  Let me know if this is helpful.
  
  - Graham

  0

  Comment actions Permalink

Please sign in to leave a comment.