Skip to main content

access_policies

Creates, updates, deletes, gets or lists an access_policies resource.

Overview

Nameaccess_policies
TypeResource
Idazure.time_series_insights.access_policies

Fields

The following fields are returned by SELECT queries:

The access policy definition was successfully retrieved and is in the response.

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
namestringThe name of the resource
propertiesobject
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
getselectsubscriptionId, resourceGroupName, environmentName, accessPolicyNameGets the access policy with the specified name in the specified environment.
list_by_environmentselectsubscriptionId, resourceGroupName, environmentNameLists all the available access policies associated with the environment.
create_or_updateinsertsubscriptionId, resourceGroupName, environmentName, accessPolicyName, data__propertiesCreate or update an access policy in the specified environment.
updateupdatesubscriptionId, resourceGroupName, environmentName, accessPolicyNameUpdates the access policy with the specified name in the specified subscription, resource group, and environment.
deletedeletesubscriptionId, resourceGroupName, environmentName, accessPolicyNameDeletes the access policy with the specified name in the specified subscription, resource group, and environment

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
accessPolicyNamestringThe name of the Time Series Insights access policy associated with the specified environment.
environmentNamestringThe name of the Time Series Insights environment associated with the specified resource group.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Gets the access policy with the specified name in the specified environment.

SELECT
id,
name,
properties,
type
FROM azure.time_series_insights.access_policies
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND environmentName = '{{ environmentName }}' -- required
AND accessPolicyName = '{{ accessPolicyName }}' -- required
;

INSERT examples

Create or update an access policy in the specified environment.

INSERT INTO azure.time_series_insights.access_policies (
data__properties,
subscriptionId,
resourceGroupName,
environmentName,
accessPolicyName
)
SELECT
'{{ properties }}' /* required */,
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ environmentName }}',
'{{ accessPolicyName }}'
RETURNING
id,
name,
properties,
type
;

UPDATE examples

Updates the access policy with the specified name in the specified subscription, resource group, and environment.

UPDATE azure.time_series_insights.access_policies
SET
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND environmentName = '{{ environmentName }}' --required
AND accessPolicyName = '{{ accessPolicyName }}' --required
RETURNING
id,
name,
properties,
type;

DELETE examples

Deletes the access policy with the specified name in the specified subscription, resource group, and environment

DELETE FROM azure.time_series_insights.access_policies
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND environmentName = '{{ environmentName }}' --required
AND accessPolicyName = '{{ accessPolicyName }}' --required
;