Advertisement
Guest User

Untitled

a guest
Aug 17th, 2019
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. COPY cnam.cnam_inftr_tnr2_updt_current_tb_bkp2
  2. FROM 's3://dev-athena/bbeckett-harrison/cnam/cnam_inftr_tnr2_updt_current_tb_bkp2_tab/manifest.json'
  3. iam_role 'arn:aws:iam::585902692734:role/myRedshiftRole'
  4. REGION 'us-west-2'
  5. ignoreheader as 1
  6. maxerror 4
  7. format as csv delimiter '\t'
  8. null as 'NULL'
  9. timeformat 'auto'
  10. manifest;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement