Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "entries" : [ {
- "url" : "s3://testings3/2018/07/22/07/mydeliverystream-3-2018-07-22-07-56-04-89605e0e-26bf-4017-a102-338ceb15481d",
- "mandatory" : true
- } ]
- }
- COPY redshiftproduct FROM 's3://testings3/mydeliverystream' CREDENTIALS 'aws_iam_role=arn:aws:iam::329723704744:role/aws-service-role/redshift.amazonaws.com/AWSServiceRoleForRedshift' delimiter ',' MANIFEST region 'us-east-1'
- Data file:
- delhi,ac,4000,2011
- Haryana,TV,5000,2001
- Channai,TV,3000,2011
- Mumbai,Laptop,4000,2012
- new delhi,ac,5000,2012
- Kolkatta,fridge,1000,2012
- Kanpur,TV,2000,2013
- Haryana,ac,2000,2019
- Kanpur,ac,2000,2019
Add Comment
Please, Sign In to add comment