Skip to content

Instantly share code, notes, and snippets.

@pcothenet
Created November 26, 2015 01:24
Show Gist options
  • Save pcothenet/5169e0b9421bbefa8e47 to your computer and use it in GitHub Desktop.
Save pcothenet/5169e0b9421bbefa8e47 to your computer and use it in GitHub Desktop.
UNLOAD ("SELECT contact_key, account_key, account_attribute_1, account_attribute_1 FROM [your_table]")
TO 's3://madkudu-data-in-[your_org_id]/group/group.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