Managing a schema in a database

In Amazon Redshift, a schema is a namespace that groups database objects such as tables, views, stored procedures, and so on. Organizing database objects in a schema is good for security monitoring, and it also means objects are logically grouped. In this recipe, we will create a sample schema that will be used to hold all the database objects.

Getting ready

To complete this recipe, you will need the following:

• Access to any SQL interface, such as Query Editor V2 or a local SQL client
• An Amazon Redshift data warehouse (serverless or provisioned cluster) endpoint
• Log in as a superuser into an Amazon Redshift cluster

How to do it…

1. Users can create a schema using the CREATE SCHEMA (https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_SCHEMA.html) command. The following steps will enable you to set up a schema with the name finance and add the necessary access to the groups:
2. User groups...