CODEWITHSUNDEEP
pythonaws-lambdaamazon-redshift
Alex B
Alex B

Reputation: 2375

How do I load data from S3 to Redshift using serverless architecture?

Is there a Python demo on how to use AWS-Lambda function to load file from S3 to AWS redshift without EC2?

Upvotes: 0

Views: 4133

Answers (2)

John Rotenstein
John Rotenstein

Reputation: 269091

There is a library available to load data into Amazon Redshift using AWS Lambda functions.

See: A Zero-Administration Amazon Redshift Database Loader

Upvotes: 1

Rich Buggy
Rich Buggy

Reputation: 289

I'm not aware of a Python demo but it shouldn't be hard to build. You need to write a Lambda to connect to Redshift then execute a COPY from S3. If you want a little more automation then you could trigger it from s3:ObjectCreated. That way uploading a file automatically copies it to Redshift.

Upvotes: 0

Related Questions