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 Analytics
  • reference
This topic describes how you use the CREATE statement to create Capella Analytics 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 Analytics resolves it as a scope name and assumes that the database is Default.

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

Example

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

 CREATE SCOPE music.myPlaylist;