Skip to main content

hubs

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

Overview

Namehubs
TypeResource
Idazure_extras.customer_insights.hubs

Fields

NameDatatypeDescription
idtextResource ID.
nametextResource name.
api_endpointtextfield from the properties object
hubNametextfield from the properties object
hub_billing_infotextfield from the properties object
locationtextResource location.
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
subscriptionIdtextfield from the properties object
tagstextResource tags.
tenant_featurestextfield from the properties object
typetextResource type.
web_endpointtextfield from the properties object

Methods

NameAccessible byRequired ParamsDescription
getSELECThubName, resourceGroupName, subscriptionIdGets information about the specified hub.
listSELECTsubscriptionIdGets all hubs in the specified subscription.
list_by_resource_groupSELECTresourceGroupName, subscriptionIdGets all the hubs in a resource group.
create_or_updateINSERThubName, resourceGroupName, subscriptionIdCreates a hub, or updates an existing hub.
deleteDELETEhubName, resourceGroupName, subscriptionIdDeletes the specified hub.
updateUPDATEhubName, resourceGroupName, subscriptionIdUpdates a Hub.

SELECT examples

Gets all hubs in the specified subscription.

SELECT
id,
name,
api_endpoint,
hubName,
hub_billing_info,
location,
provisioning_state,
resourceGroupName,
subscriptionId,
tags,
tenant_features,
type,
web_endpoint
FROM azure_extras.customer_insights.vw_hubs
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new hubs resource.

/*+ create */
INSERT INTO azure_extras.customer_insights.hubs (
hubName,
resourceGroupName,
subscriptionId,
properties,
location,
tags
)
SELECT
'{{ hubName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ location }}',
'{{ tags }}'
;

UPDATE example

Updates a hubs resource.

/*+ update */
UPDATE azure_extras.customer_insights.hubs
SET
properties = '{{ properties }}',
location = '{{ location }}',
tags = '{{ tags }}'
WHERE
hubName = '{{ hubName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified hubs resource.

/*+ delete */
DELETE FROM azure_extras.customer_insights.hubs
WHERE hubName = '{{ hubName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';