Here is the steps to Load data from AWS S3 bucket to Redshift database:
pre-request:
1)we need user created with privilege to access AWS redshift +S3 bucket
2)we need access_key_ID & secret_access_key for the user
COPY utility used to load data from S3 bukcet to AWS redshift database tables ,if the file is CSV or any delimeter format
pre-request:
1)we need user created with privilege to access AWS redshift +S3 bucket
2)we need access_key_ID & secret_access_key for the user
COPY utility used to load data from S3 bukcet to AWS redshift database tables ,if the file is CSV or any delimeter format
No comments:
Post a Comment