clusters

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

Overview

Name	clusters
Type	Resource
Id	azure_isv.vmware.clusters

Fields

vw_clusters

Name	Datatype	Description
id	text	Resource ID.
name	text	Resource name.
clusterName	text	field from the properties object
cluster_id	text	field from the properties object
hosts	text	field from the properties object
privateCloudName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
sku	text	The resource model definition representing SKU
subscriptionId	text	field from the properties object
type	text	Resource type.

clusters

Name	Datatype	Description
id	string	Resource ID.
name	string	Resource name.
properties	object	The properties of a cluster
sku	object	The resource model definition representing SKU
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	clusterName, privateCloudName, resourceGroupName, subscriptionId
list	SELECT	privateCloudName, resourceGroupName, subscriptionId
create_or_update	INSERT	clusterName, privateCloudName, resourceGroupName, subscriptionId, data__properties, data__sku
delete	DELETE	clusterName, privateCloudName, resourceGroupName, subscriptionId
update	UPDATE	clusterName, privateCloudName, resourceGroupName, subscriptionId

SELECT examples

vw_clusters

SELECT
id,
name,
clusterName,
cluster_id,
hosts,
privateCloudName,
provisioning_state,
resourceGroupName,
sku,
subscriptionId,
type
FROM azure_isv.vmware.vw_clusters
WHERE privateCloudName = '{{ privateCloudName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

clusters

SELECT
id,
name,
properties,
sku,
type
FROM azure_isv.vmware.clusters
WHERE privateCloudName = '{{ privateCloudName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.vmware.clusters (
clusterName,
privateCloudName,
resourceGroupName,
subscriptionId,
data__properties,
data__sku,
sku,
properties
)
SELECT 
'{{ clusterName }}',
'{{ privateCloudName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ data__sku }}',
'{{ sku }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: sku
      value:
        - name: name
          value: string
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: clusterId
          value: integer
        - name: hosts
          value:
            - string

UPDATE example

Updates a clusters resource.

/*+ update */
UPDATE azure_isv.vmware.clusters
SET 
properties = '{{ properties }}'
WHERE 
clusterName = '{{ clusterName }}'
AND privateCloudName = '{{ privateCloudName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified clusters resource.

/*+ delete */
DELETE FROM azure_isv.vmware.clusters
WHERE clusterName = '{{ clusterName }}'
AND privateCloudName = '{{ privateCloudName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';