Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Send and Process events to Redshift from EventBridge

0

Hi Team,

I am trying to run SQL statements in Redshift by triggering using EventBridge on S3 file arrival. I am able to run SQLs using Data API but how ever I want to pass the event details to redshift to dynamically pass the S3 key of new arrived file and copy the S3 files to redshift. Is there a way to send the events to RS and how do we process them. Appreciate any help here. Thank you!

Topics
AnalyticsApplication IntegrationServerlessStorageDatabase
Tags
AWS Data PipelineAmazon RedshiftExtract Transform & Load DataAmazon Simple Storage ServiceAmazon EventBridge
Language
English
asked 2 years ago1.4K views
1 Answer
0

Hi,

I think, this code sample covers majority of the solution you are looking for. Please check this Building Event Driven Application with AWS Lambda and Amazon Redshift Data API. If you re-use just the extract and load part, you should be able to implement what you are looking for. Also, Instead of using the scheduled event bridge event, just use your actual event.

Thanks, Rama

AWS
EXPERT
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content