How do I pick data from S3/RedShift and do some aggregation operations and insert data back into RedShift table.
Hi All, I am very new to SumoLogic, Please bear with me if i am asking a very simple question. We are using AWS RedShift as our end point. Before that all my data which is generated by IoT Devices are stored in S3 bucket and then they are moved to RedShift eventually (Every 15 min) I wanted to perform some aggregation operation where i need to combine to tables data into 1 table data. Is this possible in SumoLogic.? Can you Please help me in this issue. Thanks, Rakesh Kalwa.
-
Right now there are 2 ways you can integrate with a third-party API from Sumo (other than with ServiceNow): (1) via a Script Action (you need a local box with a local Sumo collector - you'll need to write a script/program to read the search output saved on the same box and send it to the third party - http://help.sumologic.com/Send_Data/Sources/Script_Action), (2) via a Webhook Connection (http://help.sumologic.com/Manage/Connections/Webhook_Connections). Webhook connection currently supports only basic and static authentication. I think (1) is likely your option here. A hybrid approach could be using webhook to send data (unencrypted) to a Web App that takes the data and forward to Redshift - obviously you'll need to build such webapp.
Please sign in to leave a comment.
Comments
1 comment