Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

Manage Capella Analytics Services Scopes

  • Capella Analytics
  • how-to
    +
    Scopes are intermediary containers within a database to group related objects like collections, indexes, links, and functions. You can add or delete scopes using the UI or SQL++ for Capella Analytics statements.

    Prerequisites

    To use the Capella Analytics UI to manage scopes, you need one of the following Capella roles:

    Create a Scope

    To create a scope:

    1. In the Capella UI, select the Capella Analytics tab.

    2. Click a cluster name. The workbench opens.

    3. Use the explorer to locate the database where you want to add the scope.

    4. Move your cursor over the name of the database and then choose ⋮ (More)  Add Scope. The Configure New Scope dialog opens.

    5. Enter a name for your scope. The name must start with a letter and contain only upper- and lower-case letters (A-Z, a-z), numbers (0-9), or underscore (_) and dash (-) characters. See Requirements for Identifiers.

    6. Click Create. Your scope appears under the database in the explorer.

    You can also use an SQL++ for Capella Analytics statement to create a scope. See CREATE SCOPE Statements.

    View Metadata for a Scope

    Each time you add a scope, Capella Analytics records its metadata in the System.Metadata.Dataverse collection. To view metadata for a scope, you query this collection. See Querying Metadata.

    Delete a Scope

    When you delete a scope, Capella Analytics deletes all of the collections and other objects in that scope.

    You cannot delete the system-supplied Default scope.

    1. In the Capella UI, select the Capella Analytics tab.

    2. Click a cluster name. The workbench opens.

    3. Move your cursor over the name of the scope and then choose ⋮ (More)  Delete Scope. The Delete Scope dialog opens.

    4. To confirm this action, type delete and then click Delete.

    You can also use an SQL++ for Capella Analytics statement to delete a scope. See DROP Statements.

    Next Steps