Skip to main content

cassandra_views

Creates, updates, deletes, gets or lists a cassandra_views resource.

Overview

Namecassandra_views
TypeResource
Idazure.cosmos_db.cassandra_views

Fields

The following fields are returned by SELECT queries:

The Cassandra view property was retrieved successfully.

NameDatatypeDescription
idstringThe unique resource identifier of the ARM resource.
namestringThe name of the ARM resource.
identityobjectIdentity for the resource.
locationstringThe location of the resource group to which the resource belongs.
propertiesobjectThe properties of an Azure Cosmos DB Cassandra view
tagsobjectTags are a list of key-value pairs that describe the resource. These tags can be used in viewing and grouping this resource (across resource groups). A maximum of 15 tags can be provided for a resource. Each tag must have a key no greater than 128 characters and value no greater than 256 characters. For example, the default experience for a template type is set with "defaultExperience": "Cassandra". Current "defaultExperience" values also include "Table", "Graph", "DocumentDB", and "MongoDB".
typestringThe type of Azure resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, accountName, keyspaceName, viewNameGets the Cassandra view under an existing Azure Cosmos DB database account.
listselectsubscriptionId, resourceGroupName, accountName, keyspaceNameLists the Cassandra materialized views under an existing Azure Cosmos DB database account.
create_updateinsertsubscriptionId, resourceGroupName, accountName, keyspaceName, viewName, data__propertiesCreate or update an Azure Cosmos DB Cassandra View
deletedeletesubscriptionId, resourceGroupName, accountName, keyspaceName, viewNameDeletes an existing Azure Cosmos DB Cassandra view.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
accountNamestringCosmos DB database account name.
keyspaceNamestringCosmos DB keyspace name.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.
viewNamestringCosmos DB view name.

SELECT examples

Gets the Cassandra view under an existing Azure Cosmos DB database account.

SELECT
id,
name,
identity,
location,
properties,
tags,
type
FROM azure.cosmos_db.cassandra_views
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND accountName = '{{ accountName }}' -- required
AND keyspaceName = '{{ keyspaceName }}' -- required
AND viewName = '{{ viewName }}' -- required
;

INSERT examples

Create or update an Azure Cosmos DB Cassandra View

INSERT INTO azure.cosmos_db.cassandra_views (
data__properties,
data__location,
data__tags,
data__identity,
subscriptionId,
resourceGroupName,
accountName,
keyspaceName,
viewName
)
SELECT
'{{ properties }}' /* required */,
'{{ location }}',
'{{ tags }}',
'{{ identity }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ accountName }}',
'{{ keyspaceName }}',
'{{ viewName }}'
RETURNING
id,
name,
identity,
location,
properties,
tags,
type
;

DELETE examples

Deletes an existing Azure Cosmos DB Cassandra view.

DELETE FROM azure.cosmos_db.cassandra_views
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
AND keyspaceName = '{{ keyspaceName }}' --required
AND viewName = '{{ viewName }}' --required
;