Skip to main content

profiles

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

Overview

Nameprofiles
TypeResource
Idazure.network.profiles

Fields

NameDatatypeDescription
idtextResource ID.
nametextResource name.
container_network_interface_configurationstextfield from the properties object
container_network_interfacestextfield from the properties object
etagtextA unique read-only string that changes whenever the resource is updated.
locationtextResource location.
networkProfileNametextfield from the properties object
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
resource_guidtextfield from the properties object
subscriptionIdtextfield from the properties object
tagstextResource tags.
typetextResource type.

Methods

NameAccessible byRequired ParamsDescription
getSELECTnetworkProfileName, resourceGroupName, subscriptionIdGets the specified network profile in a specified resource group.
listSELECTresourceGroupName, subscriptionIdGets all network profiles in a resource group.
list_allSELECTsubscriptionIdGets all the network profiles in a subscription.
create_or_updateINSERTnetworkProfileName, resourceGroupName, subscriptionIdCreates or updates a network profile.
deleteDELETEnetworkProfileName, resourceGroupName, subscriptionIdDeletes the specified network profile.
update_tagsEXECnetworkProfileName, resourceGroupName, subscriptionIdUpdates network profile tags.

SELECT examples

Gets all the network profiles in a subscription.

SELECT
id,
name,
container_network_interface_configurations,
container_network_interfaces,
etag,
location,
networkProfileName,
provisioning_state,
resourceGroupName,
resource_guid,
subscriptionId,
tags,
type
FROM azure.network.vw_profiles
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

/*+ create */
INSERT INTO azure.network.profiles (
networkProfileName,
resourceGroupName,
subscriptionId,
properties,
id,
location,
tags
)
SELECT
'{{ networkProfileName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ id }}',
'{{ location }}',
'{{ tags }}'
;

DELETE example

Deletes the specified profiles resource.

/*+ delete */
DELETE FROM azure.network.profiles
WHERE networkProfileName = '{{ networkProfileName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';