Configure a new Redshift schema for Datacoral transformations

Steps to create your own Redshift schema

  • Create the schema
CREATE SCHEMA IF NOT EXISTS <schema name>;
  • Grant the datacoral group access to the schema
GRANT ALL ON SCHEMA <schema name> TO GROUP datacoral;
  • Grant the datacoral user access to the schema
GRANT ALL ON SCHEMA <schema name> TO datacoral;
  • Grant the datacoral user all privileges to all tables in the schema
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA <schema name> TO datacoral;
  • Grant the datacoral user all privileges to tables that are newly created in the schema
ALTER DEFAULT PRIVILEGES IN SCHEMA <schema name> GRANT ALL ON TABLES TO datacoral;