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.

CREATE SCOPE Statements

  • Capella Columnar
  • reference
    +
    This topic describes how you use the CREATE statement to create Capella Columnar scopes.

    For general CREATE statement syntax, see CREATE Statements.

    Syntax

    CreateScope EBNF 
    CreateScope ::= "CREATE" "ANALYTICS"? "SCOPE" DatabaseAndScopeName ("IF" "NOT" "EXISTS")?

    Synonym for SCOPE: DATAVERSE

    CreateScope Diagram
    CREATE
    DatabaseAndScopeName Diagram
    (Identifier
    DatabaseAndScopeName

    The DatabaseAndScopeName represents two identifiers separated by a dot character ., where the first identifier is the database name and the second identifier is the scope name.

    If a single identifier is present, Capella Columnar resolves it as a scope name and assumes that the database is Default.

    For more information about how Capella Columnar organizes entities into a database.scope.database_object hierarchy and resolves names, see Entities in Capella Columnar Services.

    Example

    The following example creates a scope with the name myPlaylist in the music database.

     CREATE SCOPE music.myPlaylist;