Skip to content

Instantly share code, notes, and snippets.

@FernandoCutire

FernandoCutire/unload_redshift.sql

Last active July 12, 2024 18:40
Show Gist options
  • Save FernandoCutire/d936de2f111801c91917129221e4d40f to your computer and use it in GitHub Desktop.
Save FernandoCutire/d936de2f111801c91917129221e4d40f to your computer and use it in GitHub Desktop.
Download ZIP
Unload the data from a redshift table to an s3 path
Raw
unload_redshift.sql
UNLOAD ('SELECT * FROM your_redshift_table')
TO 's3://your-bucket/path/to/export/'
IAM_ROLE 'arn:aws:iam::your-account-id:role/your-redshift-role'
FORMAT AS PARQUET;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment