Skip to content

Instantly share code, notes, and snippets.

@pcothenet

pcothenet/identify_unload.md

Last active November 26, 2015 01:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pcothenet/f705e94309987ef11ad3 to your computer and use it in GitHub Desktop.
Save pcothenet/f705e94309987ef11ad3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
identify_unload.md 
UNLOAD ("SELECT contact_key, email, attribute_1, attribute_2 FROM [your_table]")
TO 's3://madkudu-data-in-[your_org_id]/identify/identify.csv'
CREDENTIALS 'aws_access_key_id=[your_access_key];aws_secret_access_key=[your_secret_key]'
DELIMITER '~'
ADDQUOTES
ESCAPE
MANIFEST
GZIP
ALLOWOVERWRITE
PARALLEL ON
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment