Single Schema per Data Warehouse Instance
The current version of Data Warehouse does not permit creation of your own schemata. When you provision a Data Warehouse instance, a default schema with the same name as the DW_ID is created and automatically added into your search path. As a result, you are not required to qualify your tables and views with the schema name.
To separate a logical group of entities, establish a naming convention, for example, “in_” prefix for input stage tables.