Skip to content

Instantly share code, notes, and snippets.

Last active January 3, 2023 21:20
What would you like to do?
-- switch redshift database connection to new demo database before continuing!
-- create external tables schema and new glue data catalog
create external schema tickit_external
from data catalog
database 'tickit_dbt'
iam_role 'arn:aws:iam::<your_aws_acccount_id>:role/ClusterPermissionsRole'
create external database if not exists;
create schema tickit_dbt;
drop schema public;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment