vw_fleets

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

Overview

Name	vw_fleets
Type	View
Id	azure.azure_fleet.vw_fleets

Fields

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition

Sqlite3

SELECT
location as location,
zones as zones,
identity as identity,
plan as plan,
tags as tags,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.spotPriorityProfile') as "spot_priority_profile",
JSON_EXTRACT(properties, '$.regularPriorityProfile') as "regular_priority_profile",
JSON_EXTRACT(properties, '$.vmSizesProfile') as "vm_sizes_profile",
JSON_EXTRACT(properties, '$.computeProfile') as "compute_profile",
JSON_EXTRACT(properties, '$.timeCreated') as "time_created",
JSON_EXTRACT(properties, '$.uniqueId') as "unique_id",
subscriptionId,
resourceGroupName,
fleetName
FROM azure.azure_fleet.fleets
WHERE subscriptionId = 'replace-me';

Postgres

SELECT
location as location,
zones as zones,
identity as identity,
plan as plan,
tags as tags,
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.spotPriorityProfile') as "spot_priority_profile",
json_extract_path_text(properties, '$.regularPriorityProfile') as "regular_priority_profile",
json_extract_path_text(properties, '$.vmSizesProfile') as "vm_sizes_profile",
json_extract_path_text(properties, '$.computeProfile') as "compute_profile",
json_extract_path_text(properties, '$.timeCreated') as "time_created",
json_extract_path_text(properties, '$.uniqueId') as "unique_id",
subscriptionId,
resourceGroupName,
fleetName
FROM azure.azure_fleet.fleets
WHERE subscriptionId = 'replace-me';