To create a new schema, use the
CREATE SCHEMA SQL command. For example:
CREATE SCHEMA IF NOT EXISTS "my_new_schema";
Use the Workbench tool/page in Panoply or any third-party SQL client tool to execute the statement above. Replace
my_new_schema with your own schema name.
A few notes on creating schemas in Panoply:
- Only the Panoply account owner can create new schemas by default. If you're a user that's part of an account admins team and haven't been granted permission to create new schemas, you'll encounter a permission denied error.
- If you plan to allow other users permission to create schemas, you can request or contact email@example.com. Provide the user's email and the database you want to grant permission to. But first, ensure the user you'll be giving access is a member of your Panoply account's Admins team.
- After you create a schema, you can then set any data source to populate data into it. The new schema will be listed in the Schema selection, under the Advanced options of a data source's configuration page.
- To grant specific permissions on a table (or all tables in a schema) to a user or a group, use our Users tab groups or ask Panoply's support for help.
NOTE: Currently, when using the Workbench tool/page in Panoply to create a new schema, you'll have no UI feedback or notification to tell you if the
CREATE SCHEMA statement you executed was successful or not. As long as no errors were displayed, it's safe to assume that it was created successfully.
Also, newly created schemas are not displayed immediately in the Workbench. Regarding this behavior, please read the "Why can't I locate my newly created schema?" article.