Skip to main content

fleets

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

Overview

Namefleets
TypeResource
Idazure.azure_fleet.fleets

Fields

NameDatatypeDescription
compute_profiletextfield from the properties object
fleetNametextfield from the properties object
identitytextManaged service identity (system assigned and/or user assigned identities)
locationtextThe geo-location where the resource lives
plantextPlan for the resource.
provisioning_statetextfield from the properties object
regular_priority_profiletextfield from the properties object
resourceGroupNametextfield from the properties object
spot_priority_profiletextfield from the properties object
subscriptionIdtextfield from the properties object
tagstextResource tags.
time_createdtextfield from the properties object
unique_idtextfield from the properties object
vm_sizes_profiletextfield from the properties object
zonestextZones in which the Compute Fleet is available

Methods

NameAccessible byRequired ParamsDescription
getSELECTfleetName, resourceGroupName, subscriptionIdGet a Fleet
list_by_resource_groupSELECTresourceGroupName, subscriptionIdList Fleet resources by resource group
list_by_subscriptionSELECTsubscriptionIdList Fleet resources by subscription ID
create_or_updateINSERTfleetName, resourceGroupName, subscriptionIdCreate a Fleet
deleteDELETEfleetName, resourceGroupName, subscriptionIdDelete a Fleet
updateUPDATEfleetName, resourceGroupName, subscriptionIdUpdate a Fleet

SELECT examples

List Fleet resources by subscription ID

SELECT
compute_profile,
fleetName,
identity,
location,
plan,
provisioning_state,
regular_priority_profile,
resourceGroupName,
spot_priority_profile,
subscriptionId,
tags,
time_created,
unique_id,
vm_sizes_profile,
zones
FROM azure.azure_fleet.vw_fleets
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

/*+ create */
INSERT INTO azure.azure_fleet.fleets (
fleetName,
resourceGroupName,
subscriptionId,
properties,
zones,
identity,
plan,
tags,
location
)
SELECT
'{{ fleetName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ zones }}',
'{{ identity }}',
'{{ plan }}',
'{{ tags }}',
'{{ location }}'
;

UPDATE example

Updates a fleets resource.

/*+ update */
UPDATE azure.azure_fleet.fleets
SET
tags = '{{ tags }}',
identity = '{{ identity }}',
plan = '{{ plan }}',
properties = '{{ properties }}'
WHERE
fleetName = '{{ fleetName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified fleets resource.

/*+ delete */
DELETE FROM azure.azure_fleet.fleets
WHERE fleetName = '{{ fleetName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';