Skip to content

Instantly share code, notes, and snippets.

@pcothenet

pcothenet/track_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/9436dac3ca112c3526dc to your computer and use it in GitHub Desktop.
Save pcothenet/9436dac3ca112c3526dc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
track_unload.md 
UNLOAD ("SELECT event_text, event_timestamp, contact_key, event_attribute_1, event_attribute_2 FROM [your_table]")
TO 's3://madkudu-data-in-[your_org_id]/track/track.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