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 Enterprise Analytics Databases

  • how-to
    +
    In an Enterprise Analytics cluster, a database is the top-level container for organizing related information.You can add or delete databases using the UI or SQL++ for Enterprise Analytics statements.

    Prerequisites

    To use the Enterprise Analytics UI to manage databases, you need the Enterprise Analytics Access role along with specific privileges.

    Create a Database

    To create a database:

    1. In the UI, select the Workbench tab.

    2. Under Databases, click + database.

    3. Enter a name for your database, and optionally, 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.

    4. Click Create.

    You can also use an SQL++ statement to create a database. See CREATE DATABASE Statements.

    View Metadata for a Database

    Each time you add a database, Enterprise Analytics records its metadata in the System.Metadata.Database collection. To view metadata for a database, you query this collection. See Querying Metadata.

    Delete a Database

    When you delete a database, Enterprise Analytics deletes all of the scopes, collections, and other objects in that database.

    You cannot delete the system-supplied Default database.

    1. In the UI, select the Workbench tab.

    2. Browse to the database you want to delete and click the Recycle Bin icon.

    3. To confirm that you want to delete the database, click OK.

    You can also use an SQL++ statement to delete a database. See DROP Statements.

    Next Steps