Skip to main content

web_pub_sub

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

Overview

Nameweb_pub_sub
TypeResource
Idazure.web_pubsub.web_pub_sub

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
capacityobjectDescribes scaling information of a sku.
resourceTypestringThe resource type that this object applies to.
skuobjectThe billing information of the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
list_replica_skusselectresource_group_name, resource_name, replica_name, subscription_idList all available skus of the replica resource.
check_name_availabilityselectlocation, subscription_idChecks that the resource name is valid and is not already in use.
getselectresource_group_name, resource_name, subscription_idGet the resource and its properties.
list_by_resource_groupselectresource_group_name, subscription_idHandles requests to list all resources in a resource group.
list_by_subscriptionselectsubscription_idHandles requests to list all resources in a subscription.
create_or_updateinsertresource_group_name, resource_name, subscription_id, locationCreate or update a resource.
updateupdateresource_group_name, resource_name, subscription_id, locationOperation to update an exiting resource.
create_or_updatereplaceresource_group_name, resource_name, subscription_id, locationCreate or update a resource.
deletedeleteresource_group_name, resource_name, subscription_idOperation to delete a resource.
list_keysexecresource_group_name, resource_name, subscription_idGet the access keys of the resource.
list_skusexecresource_group_name, resource_name, subscription_idList all available skus of the resource.
regenerate_keyexecresource_group_name, resource_name, subscription_idRegenerate the access key for the resource. PrimaryKey and SecondaryKey cannot be regenerated at the same time.
restartexecresource_group_name, resource_name, subscription_idOperation to restart a resource.

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
locationstringthe region. Required.
replica_namestringThe name of the replica. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
resource_namestringThe name of the resource. Required.
subscription_idstring

SELECT examples

List all available skus of the replica resource.

SELECT
capacity,
resourceType,
sku
FROM azure.web_pubsub.web_pub_sub
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND resource_name = '{{ resource_name }}' -- required
AND replica_name = '{{ replica_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create or update a resource.

INSERT INTO azure.web_pubsub.web_pub_sub (
tags,
location,
sku,
kind,
identity,
properties,
resource_group_name,
resource_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ sku }}',
'{{ kind }}',
'{{ identity }}',
'{{ properties }}',
'{{ resource_group_name }}',
'{{ resource_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
identity,
kind,
location,
properties,
sku,
systemData,
tags,
type
;

UPDATE examples

Operation to update an exiting resource.

UPDATE azure.web_pubsub.web_pub_sub
SET
tags = '{{ tags }}',
location = '{{ location }}',
sku = '{{ sku }}',
kind = '{{ kind }}',
identity = '{{ identity }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND resource_name = '{{ resource_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
identity,
kind,
location,
properties,
sku,
systemData,
tags,
type;

REPLACE examples

Create or update a resource.

REPLACE azure.web_pubsub.web_pub_sub
SET
tags = '{{ tags }}',
location = '{{ location }}',
sku = '{{ sku }}',
kind = '{{ kind }}',
identity = '{{ identity }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND resource_name = '{{ resource_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
identity,
kind,
location,
properties,
sku,
systemData,
tags,
type;

DELETE examples

Operation to delete a resource.

DELETE FROM azure.web_pubsub.web_pub_sub
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND resource_name = '{{ resource_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

Get the access keys of the resource.

EXEC azure.web_pubsub.web_pub_sub.list_keys 
@resource_group_name='{{ resource_group_name }}' --required,
@resource_name='{{ resource_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;