Skip to main content

service

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

Overview

Nameservice
TypeResource
Idazure.cosmosdb.service

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
creationTimestring (date-time)Time of the last state change (ISO-8601 format).
instanceCountintegerInstance count for the service.
instanceSizestringInstance type for the service. Known values are: "Cosmos.D4s", "Cosmos.D8s", and "Cosmos.D16s". (Cosmos.D4s, Cosmos.D8s, Cosmos.D16s)
serviceTypestringServiceType for the service. Required. Known values are: "SqlDedicatedGateway", "DataTransfer", "GraphAPICompute", and "MaterializedViewsBuilder".
statusstringDescribes the status of a service. Known values are: "Creating", "Running", "Updating", "Deleting", "Error", and "Stopped". (Creating, Running, Updating, Deleting, Error, Stopped)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, account_name, service_name, subscription_idGets the status of service.
listselectresource_group_name, account_name, subscription_idGets the status of service.
createinsertresource_group_name, account_name, service_name, subscription_idCreates a service.
deletedeleteresource_group_name, account_name, service_name, subscription_idDeletes service with the given serviceName.

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
account_namestringCosmos DB database account name. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
service_namestringCosmos DB service name. Required.
subscription_idstring

SELECT examples

Gets the status of service.

SELECT
id,
name,
creationTime,
instanceCount,
instanceSize,
serviceType,
status,
systemData,
type
FROM azure.cosmosdb.service
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND account_name = '{{ account_name }}' -- required
AND service_name = '{{ service_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates a service.

INSERT INTO azure.cosmosdb.service (
properties,
resource_group_name,
account_name,
service_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ resource_group_name }}',
'{{ account_name }}',
'{{ service_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

DELETE examples

Deletes service with the given serviceName.

DELETE FROM azure.cosmosdb.service
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND account_name = '{{ account_name }}' --required
AND service_name = '{{ service_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;