Skip to main content

stack_associated_resources

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

Overview​

Namestack_associated_resources
TypeResource
Idoci.resource_manager.stack_associated_resources

Fields​

The following fields are returned by SELECT queries:

A list of associated resources.

NameDatatypeDescription
attributesobjectResource attribute values. Each value is represented as a key-value pair. Example: {"state": "AVAILABLE"}
regionstringResource region. For information about regions, see [Regions and Availability Domains](/iaas/Content/General/Concepts/regions.htm). Example: us-phoenix-1
resourceAddressstringTerraform resource address.
resourceIdstringUnique identifier for the resource.
resourceNamestringName of the resource.
resourceTypestringResource type. For more information about resource types supported for the Oracle Cloud Infrastructure (OCI) provider, see [Oracle Cloud Infrastructure Provider](https:​//registry.terraform.io/providers/oracle/oci/latest/docs).
timeCreatedstring (date-time)The date and time when the stack was created. Format is defined by RFC3339. Example: 2022-07-25T21:10:29.600Z

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectstackId, regionopc-request-id, terraformResourceType, compartmentId, limit, pageGets the list of resources associated with the specified stack.<br />For more information, see<br />[Listing Stack Resources](/iaas/Content/ResourceManager/Tasks/list-stack-resources.htm).<br />

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
regionstringOCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION)
stackIdstringThe [OCID](/iaas/Content/General/Concepts/identifiers.htm) of the stack.
compartmentIdstringA filter to return only resources that exist in the compartment, identified by [OCID](/iaas/Content/General/Concepts/identifiers.htm).
limitintegerThe number of items returned in a paginated List call. For information about pagination, see [List Pagination](/iaas/Content/API/Concepts/usingapi.htm#nine).
opc-request-idstringUnique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
pagestringThe value of the opc-next-page response header from the preceding List call. For information about pagination, see [List Pagination](/iaas/Content/API/Concepts/usingapi.htm#nine).
terraformResourceTypestringA filter to return only specified resource types. For more information about resource types supported for the Oracle Cloud Infrastructure [OCI] provider, see [Oracle Cloud Infrastructure Provider](https:​//registry.terraform.io/providers/oracle/oci/latest/docs).

SELECT examples​

Gets the list of resources associated with the specified stack.<br />For more information, see<br />[Listing Stack Resources](/iaas/Content/ResourceManager/Tasks/list-stack-resources.htm).<br />

SELECT
attributes,
region,
resourceAddress,
resourceId,
resourceName,
resourceType,
timeCreated
FROM oci.resource_manager.stack_associated_resources
WHERE stackId = '{{ stackId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
AND terraformResourceType = '{{ terraformResourceType }}'
AND compartmentId = '{{ compartmentId }}'
AND limit = '{{ limit }}'
AND page = '{{ page }}'
;