Skip to content

Instantly share code, notes, and snippets.

@mbiemann

mbiemann/aws-redshift.sql

Created September 8, 2020 15:09
Show Gist options
  • Save mbiemann/3a526202338abb9521b5bbfdd025a05d to your computer and use it in GitHub Desktop.
Save mbiemann/3a526202338abb9521b5bbfdd025a05d to your computer and use it in GitHub Desktop.
Download ZIP
AWS Redshift SQL Commands
Raw
aws-redshift.sql
-- CREATE EXTENAL SCHEMA
-- https://docs.aws.amazon.com/pt_br/redshift/latest/dg/r_CREATE_EXTERNAL_SCHEMA.html
CREATE EXTERNAL SCHEMA 'yourDatabase'
FROM DATA CATALOG DATABASE 'yourDatabase'
REGION 'us-east-1'
IAM_ROLE 'arn:aws:iam::ACCOUNT_ID:role/ROLE_NAME';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment