Skip to main content

resource_anchors

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

Overview

Nameresource_anchors
TypeResource
Idazure_isv.oracledatabase.resource_anchors

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
linkedCompartmentIdstringOracle Cloud Infrastructure compartment Id (ocid) which was created or linked by customer with resource anchor. This compartmentId is different from where resource Anchor lives.
locationstringThe geo-location where the resource lives. Required.
provisioningStatestringResourceAnchor provisioning state. Known values are: "Succeeded", "Failed", "Canceled", and "Provisioning". (Succeeded, Failed, Canceled, Provisioning)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
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
getselectresource_group_name, resource_anchor_name, subscription_idGet a ResourceAnchor.
list_by_resource_groupselectresource_group_name, subscription_idList ResourceAnchor resources by resource group.
list_by_subscriptionselectsubscription_idList ResourceAnchor resources by subscription ID.
create_or_updateinsertresource_group_name, resource_anchor_name, subscription_id, locationCreate a ResourceAnchor.
updateupdateresource_group_name, resource_anchor_name, subscription_idUpdate a ResourceAnchor.
create_or_updatereplaceresource_group_name, resource_anchor_name, subscription_id, locationCreate a ResourceAnchor.
deletedeleteresource_group_name, resource_anchor_name, subscription_idDelete a ResourceAnchor.

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
resource_anchor_namestringThe name of the ResourceAnchor. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Get a ResourceAnchor.

SELECT
id,
name,
linkedCompartmentId,
location,
provisioningState,
systemData,
tags,
type
FROM azure_isv.oracledatabase.resource_anchors
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND resource_anchor_name = '{{ resource_anchor_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create a ResourceAnchor.

INSERT INTO azure_isv.oracledatabase.resource_anchors (
tags,
location,
properties,
resource_group_name,
resource_anchor_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ resource_group_name }}',
'{{ resource_anchor_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type
;

UPDATE examples

Update a ResourceAnchor.

UPDATE azure_isv.oracledatabase.resource_anchors
SET
tags = '{{ tags }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND resource_anchor_name = '{{ resource_anchor_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

REPLACE examples

Create a ResourceAnchor.

REPLACE azure_isv.oracledatabase.resource_anchors
SET
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND resource_anchor_name = '{{ resource_anchor_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

DELETE examples

Delete a ResourceAnchor.

DELETE FROM azure_isv.oracledatabase.resource_anchors
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND resource_anchor_name = '{{ resource_anchor_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;