create_external_schema.sql

-- 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;