Skip to content

Instantly share code, notes, and snippets.

@vithalsamp

vithalsamp/redshift file2.sql

Created February 26, 2018 09:05
Show Gist options
  • Save vithalsamp/f058fd131cd24d6461910be52f85d92f to your computer and use it in GitHub Desktop.
Save vithalsamp/f058fd131cd24d6461910be52f85d92f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
redshift file2.sql
training=# copy sample_test_single_col from 's3://testbucket/Sample_fixed_width.txt' CREDENTIALS
training-# 'aws_access_key_id=xxxxxxx; aws_secret_access_key=yyyyyyyy' ;
INFO: Load into table 'sample_test_single_col' completed, 17 record(s) loaded successfully.
COPY
training=# select * from sample_test_single_col limit 2;
single_col
----------------------------------------------------
16524 01 10172012 3930621977 TXNPUES
191667 01 01142013 3714468136 GHAKASC QHJXDFM
(2 rows)
training=#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment