autonomous_virtual_machines

Creates, updates, deletes, gets or lists an autonomous_virtual_machines resource.

Overview

Name	autonomous_virtual_machines
Type	Resource
Id	aws.odb.autonomous_virtual_machines

Fields

The following fields are returned by SELECT queries:

list_autonomous_virtual_machines

Name	Datatype	Description
autonomous_virtual_machine_id	string	The unique identifier of the Autonomous VM. (pattern: <code>[a-zA-Z0-9_~.-]+</code>)
client_ip_address	string	The IP address used by clients to connect to this Autonomous VM.
cloud_autonomous_vm_cluster_id	string	The unique identifier of the Autonomous VM cluster containing this Autonomous VM.
cpu_core_count	integer	The number of CPU cores allocated to this Autonomous VM.
db_node_storage_size_in_gbs	integer	The amount of storage allocated to this Autonomous Virtual Machine, in gigabytes (GB).
db_server_display_name	string	The display name of the database server hosting this Autonomous VM.
db_server_id	string	The unique identifier of the database server hosting this Autonomous VM. (pattern: <code>[a-zA-Z0-9_~.-]+</code>)
memory_size_in_gbs	integer	The amount of memory allocated to this Autonomous VM, in gigabytes (GB).
oci_resource_anchor_name	string	The name of the Oracle Cloud Infrastructure (OCI) resource anchor associated with this Autonomous VM.
ocid	string	The Oracle Cloud Identifier (OCID) of the Autonomous VM.
status	string	The current status of the Autonomous VM. (AVAILABLE, FAILED, PROVISIONING, TERMINATED, TERMINATING, UPDATING, MAINTENANCE_IN_PROGRESS)
status_reason	string	Additional information about the current status of the Autonomous VM, if applicable.
vm_name	string	The name of the Autonomous VM.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_autonomous_virtual_machines	select	region		Lists all Autonomous VMs in an Autonomous VM cluster.

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.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)

SELECT examples

list_autonomous_virtual_machines

Lists all Autonomous VMs in an Autonomous VM cluster.

SELECT
autonomous_virtual_machine_id,
client_ip_address,
cloud_autonomous_vm_cluster_id,
cpu_core_count,
db_node_storage_size_in_gbs,
db_server_display_name,
db_server_id,
memory_size_in_gbs,
oci_resource_anchor_name,
ocid,
status,
status_reason,
vm_name
FROM aws.odb.autonomous_virtual_machines
WHERE region = '{{ region }}' -- required
;