Skip to main content

hubs

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

Overview

Namehubs
TypeResource
Idazure_extras.customer_insights.hubs

Fields

The following fields are returned by SELECT queries:

OK. Successfully get the hub.

NameDatatypeDescription
idstringResource ID.
namestringResource name.
locationstringResource location.
propertiesobjectProperties of hub.
tagsobjectResource tags.
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, hubName, subscriptionIdGets information about the specified hub.
list_by_resource_groupselectresourceGroupName, subscriptionIdGets all the hubs in a resource group.
listselectsubscriptionIdGets all hubs in the specified subscription.
create_or_updateinsertresourceGroupName, hubName, subscriptionIdCreates a hub, or updates an existing hub.
updateupdateresourceGroupName, hubName, subscriptionIdUpdates a Hub.
deletedeleteresourceGroupName, hubName, subscriptionIdDeletes the specified hub.

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
hubNamestringThe name of the hub.
resourceGroupNamestringThe name of the resource group.
subscriptionIdstringGets subscription credentials which uniquely identify Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.

SELECT examples

Gets information about the specified hub.

SELECT
id,
name,
location,
properties,
tags,
type
FROM azure_extras.customer_insights.hubs
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND hubName = '{{ hubName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Creates a hub, or updates an existing hub.

INSERT INTO azure_extras.customer_insights.hubs (
data__properties,
data__location,
data__tags,
resourceGroupName,
hubName,
subscriptionId
)
SELECT
'{{ properties }}',
'{{ location }}',
'{{ tags }}',
'{{ resourceGroupName }}',
'{{ hubName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
location,
properties,
tags,
type
;

UPDATE examples

Updates a Hub.

UPDATE azure_extras.customer_insights.hubs
SET
data__properties = '{{ properties }}',
data__location = '{{ location }}',
data__tags = '{{ tags }}'
WHERE
resourceGroupName = '{{ resourceGroupName }}' --required
AND hubName = '{{ hubName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
RETURNING
id,
name,
location,
properties,
tags,
type;

DELETE examples

Deletes the specified hub.

DELETE FROM azure_extras.customer_insights.hubs
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND hubName = '{{ hubName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;