Skip to main content

environments

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

Overview

Nameenvironments
TypeResource
Idazure.dev_test_labs.environments

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe identifier of the resource.
namestringThe name of the resource.
armTemplateDisplayNamestringThe display name of the Azure Resource Manager template that produced the environment.
createdByUserstringThe creator of the environment.
deploymentPropertiesobjectThe deployment properties of the environment.
locationstringThe location of the resource.
provisioningStatestringThe provisioning status of the resource.
resourceGroupIdstringThe identifier of the resource group containing the environment's resources.
tagsobjectThe tags of the resource.
typestringThe type of the resource.
uniqueIdentifierstringThe unique immutable identifier of a resource (Guid).

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, lab_name, user_name, name, subscription_id$expandGet environment.
listselectresource_group_name, lab_name, user_name, subscription_id$expand, $filter, $top, $orderbyList environments in a given user profile.
create_or_updateinsertresource_group_name, lab_name, user_name, name, subscription_idCreate or replace an existing environment. This operation can take a while to complete.
updateupdateresource_group_name, lab_name, user_name, name, subscription_idAllows modifying tags of environments. All other properties will be ignored.
create_or_updatereplaceresource_group_name, lab_name, user_name, name, subscription_idCreate or replace an existing environment. This operation can take a while to complete.
deletedeleteresource_group_name, lab_name, user_name, name, subscription_idDelete environment. This operation can take a while to complete.

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
lab_namestringThe name of the lab. Required.
namestringThe name of the environment. Required.
resource_group_namestringThe name of the resource group. Required.
subscription_idstring
user_namestringThe name of the user profile. Required.
$expandstringSpecify the $expand query. Example: 'properties($select=deploymentProperties)'. Default value is None.
$filterstringThe filter to apply to the operation. Example: '$filter=contains(name,'myName'). Default value is None.
$orderbystringThe ordering expression for the results, using OData notation. Example: '$orderby=name desc'. Default value is None.
$topintegerThe maximum number of resources to return from the operation. Example: '$top=10'. Default value is None.

SELECT examples

Get environment.

SELECT
id,
name,
armTemplateDisplayName,
createdByUser,
deploymentProperties,
location,
provisioningState,
resourceGroupId,
tags,
type,
uniqueIdentifier
FROM azure.dev_test_labs.environments
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND lab_name = '{{ lab_name }}' -- required
AND user_name = '{{ user_name }}' -- required
AND name = '{{ name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
AND $expand = '{{ $expand }}'
;

INSERT examples

Create or replace an existing environment. This operation can take a while to complete.

INSERT INTO azure.dev_test_labs.environments (
location,
tags,
properties,
resource_group_name,
lab_name,
user_name,
name,
subscription_id
)
SELECT
'{{ location }}',
'{{ tags }}',
'{{ properties }}',
'{{ resource_group_name }}',
'{{ lab_name }}',
'{{ user_name }}',
'{{ name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
tags,
type
;

UPDATE examples

Allows modifying tags of environments. All other properties will be ignored.

UPDATE azure.dev_test_labs.environments
SET
-- No updatable properties
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND lab_name = '{{ lab_name }}' --required
AND user_name = '{{ user_name }}' --required
AND name = '{{ name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
tags,
type;

REPLACE examples

Create or replace an existing environment. This operation can take a while to complete.

REPLACE azure.dev_test_labs.environments
SET
location = '{{ location }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND lab_name = '{{ lab_name }}' --required
AND user_name = '{{ user_name }}' --required
AND name = '{{ name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
tags,
type;

DELETE examples

Delete environment. This operation can take a while to complete.

DELETE FROM azure.dev_test_labs.environments
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND lab_name = '{{ lab_name }}' --required
AND user_name = '{{ user_name }}' --required
AND name = '{{ name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;