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 Columnar Services Databases

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

    Prerequisites

    To use the Capella Columnar UI to manage databases, you need one of the following Capella roles:

    Create a Database

    To create a database:

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

    2. Click a cluster name. The workbench opens.

      If the Add Data Source dialog opens, click the X icon to close it.

    3. At the top of the explorer, click Create  New Database. The Configure New Database dialog opens.

    4. Enter a name for your database. 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.

    5. Click Create Database. Your database appears in the explorer.

    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, Capella Columnar 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, Capella Columnar deletes all of the scopes, collections, and other objects in that database.

    You cannot delete the system-supplied Default database.

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

    2. Click a cluster name. The workbench opens.

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

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

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

    Next Steps