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
March 23, 2025
+ 12
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 
EBNF
Copy
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.

SQL++
Copy
 CREATE SCOPE music.myPlaylist;