1. Home
  2. Cloud
  3. Guides
  4. Tours
  5. Concepts
  6. Tools
    1. Alert Editor
    2. Analyzer
    3. Avro Extractor Tool
    4. Business Schema Designer
    5. Business Schema Manager
    6. CMC Logs Manager
    7. CMC Monitoring
    8. CMC Scheduler
    9. CMC Tenant Manager
    10. Content Manager
    11. Dashboard Filters Manager
    12. Dashboard Manager
    13. Data Agent
    14. Data Lineage Viewer
    15. Data Lineage Viewer v2
    16. Data Manager
    17. Formula Builder
    18. Inspector Tool
    19. Join Editor
    20. Load Job Details Viewer
    21. Load Job Viewer
    22. Load Plan DAG Viewer
    23. Model Update Viewer
    24. Notebook Editor
    25. Profile Manager
    26. Public API
    27. Query Plan Viewer
    28. Scheduler
    29. Schema Designer
    30. Schema Diagram Viewer
    31. Schema Manager
      1. Schemas
      2. Load Jobs
      3. Session Variables
      4. Global Variables
    32. Schema Wizard
    33. Security Manager
    34. Table Editor
    35. Upload Service Command Line Interface (CLI)
  7. References
  8. Integrations
  9. Data applications
  10. Releases

Tools → Schema Manager

About the Schema Manager

The Schema Manager allows a tenant user with the necessary access rights to search for, create, and manage the following:

  • Physical schemas
  • Load jobs (available starting 2022.12.0)
  • Internal, external, and filter expression session variables
  • Global variables

Schema Manager access rights

A user that belongs to a group with the Schema Manager or the SuperRole role can access the Schema Manager. To access the Schema Manager for a given tenant, in the Navigation bar, select Schema.

Note

  • In addition to global variables that are available to all tenant users, a user that belongs to a group with the Analyze User or Individual Analyzer role can access objects created in the Schema Manager (physical schemas and session variables) and shared with this user when developing or editing dashboards in the Analyzer.

  • When the Cluster Management Console (CMC) admin turns the Enable Super User Mode option on, the Super User and users with the SuperRole can manage all items on the Schema Manager regardless of the access rights.

  • Only the Super User tenant administrator can view the list of all items on the Schema Manager regardless of the access rights to them and the Enable Super User mode option.

Schema Manager anatomy

The Schema Manager consists of the following:

  • Action bar
  • Context bar
  • Search bar
  • List view

Action bar

The Action bar shows the page title.

+ New in the Action bar opens the Add New menu. The Add New menu options are:

Context bar

The Context bar consists of four tabs: Schema, Load Jobs, Session Variables, and Global Variable. Tab selection determines the search context as well as the list view results.

The Search bar contains a search text box. Search for any part of a given search term. When the Context bar tab selection is Schema, the search returns a result list of zero or more physical schemas. When the tab selection is Session Variables, the search returns a result list of zero or more session variables, whether internal, external, or filter expression session variables. When the tab selection is Global Variables, the search returns a result list of zero or more global variables.

The Search bar shows:

  • The number of items in the result list
  • The number of selected items in the result list with the option (x) to deselect the items
  • Other options that may vary depending upon the Context bar tab selection, the number of selected items, and the user access rights.

List view

The List view shows all results for a given search term and search context. By default, the list view only shows items where the given user has at least view access rights to the items.

The List view shows a specific number of items at a time. This number differs according to the selected tab. When there are items more than this number, the list view shows page controls. The page controls allow the user to navigate pages forwards or backwards as well as to the first page or to the last page of items.

For more information, refer to: