Skip to main content

vw_autonomous_databases

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

Overview​

Namevw_autonomous_databases
TypeView
Idazure_isv.oracle.vw_autonomous_databases

Fields​

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

SQL Definition​

SELECT
location as location,
tags as tags,
JSON_EXTRACT(properties, '$.adminPassword') as "admin_password",
JSON_EXTRACT(properties, '$.dataBaseType') as "data_base_type",
JSON_EXTRACT(properties, '$.autonomousMaintenanceScheduleType') as "autonomous_maintenance_schedule_type",
JSON_EXTRACT(properties, '$.characterSet') as "character_set",
JSON_EXTRACT(properties, '$.computeCount') as "compute_count",
JSON_EXTRACT(properties, '$.computeModel') as "compute_model",
JSON_EXTRACT(properties, '$.cpuCoreCount') as "cpu_core_count",
JSON_EXTRACT(properties, '$.customerContacts') as "customer_contacts",
JSON_EXTRACT(properties, '$.dataStorageSizeInTbs') as "data_storage_size_in_tbs",
JSON_EXTRACT(properties, '$.dataStorageSizeInGbs') as "data_storage_size_in_gbs",
JSON_EXTRACT(properties, '$.dbVersion') as "db_version",
JSON_EXTRACT(properties, '$.dbWorkload') as "db_workload",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.isAutoScalingEnabled') as "is_auto_scaling_enabled",
JSON_EXTRACT(properties, '$.isAutoScalingForStorageEnabled') as "is_auto_scaling_for_storage_enabled",
JSON_EXTRACT(properties, '$.peerDbIds') as "peer_db_ids",
JSON_EXTRACT(properties, '$.peerDbId') as "peer_db_id",
JSON_EXTRACT(properties, '$.isLocalDataGuardEnabled') as "is_local_data_guard_enabled",
JSON_EXTRACT(properties, '$.isRemoteDataGuardEnabled') as "is_remote_data_guard_enabled",
JSON_EXTRACT(properties, '$.localDisasterRecoveryType') as "local_disaster_recovery_type",
JSON_EXTRACT(properties, '$.localStandbyDb') as "local_standby_db",
JSON_EXTRACT(properties, '$.failedDataRecoveryInSeconds') as "failed_data_recovery_in_seconds",
JSON_EXTRACT(properties, '$.isMtlsConnectionRequired') as "is_mtls_connection_required",
JSON_EXTRACT(properties, '$.isPreviewVersionWithServiceTermsAccepted') as "is_preview_version_with_service_terms_accepted",
JSON_EXTRACT(properties, '$.licenseModel') as "license_model",
JSON_EXTRACT(properties, '$.ncharacterSet') as "ncharacter_set",
JSON_EXTRACT(properties, '$.lifecycleDetails') as "lifecycle_details",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.lifecycleState') as "lifecycle_state",
JSON_EXTRACT(properties, '$.scheduledOperations') as "scheduled_operations",
JSON_EXTRACT(properties, '$.privateEndpointIp') as "private_endpoint_ip",
JSON_EXTRACT(properties, '$.privateEndpointLabel') as "private_endpoint_label",
JSON_EXTRACT(properties, '$.ociUrl') as "oci_url",
JSON_EXTRACT(properties, '$.subnetId') as "subnet_id",
JSON_EXTRACT(properties, '$.vnetId') as "vnet_id",
JSON_EXTRACT(properties, '$.timeCreated') as "time_created",
JSON_EXTRACT(properties, '$.timeMaintenanceBegin') as "time_maintenance_begin",
JSON_EXTRACT(properties, '$.timeMaintenanceEnd') as "time_maintenance_end",
JSON_EXTRACT(properties, '$.actualUsedDataStorageSizeInTbs') as "actual_used_data_storage_size_in_tbs",
JSON_EXTRACT(properties, '$.allocatedStorageSizeInTbs') as "allocated_storage_size_in_tbs",
JSON_EXTRACT(properties, '$.apexDetails') as "apex_details",
JSON_EXTRACT(properties, '$.availableUpgradeVersions') as "available_upgrade_versions",
JSON_EXTRACT(properties, '$.connectionStrings') as "connection_strings",
JSON_EXTRACT(properties, '$.connectionUrls') as "connection_urls",
JSON_EXTRACT(properties, '$.dataSafeStatus') as "data_safe_status",
JSON_EXTRACT(properties, '$.databaseEdition') as "database_edition",
JSON_EXTRACT(properties, '$.autonomousDatabaseId') as "autonomous_database_id",
JSON_EXTRACT(properties, '$.inMemoryAreaInGbs') as "in_memory_area_in_gbs",
JSON_EXTRACT(properties, '$.nextLongTermBackupTimeStamp') as "next_long_term_backup_time_stamp",
JSON_EXTRACT(properties, '$.longTermBackupSchedule') as "long_term_backup_schedule",
JSON_EXTRACT(properties, '$.isPreview') as "is_preview",
JSON_EXTRACT(properties, '$.localAdgAutoFailoverMaxDataLossLimit') as "local_adg_auto_failover_max_data_loss_limit",
JSON_EXTRACT(properties, '$.memoryPerOracleComputeUnitInGbs') as "memory_per_oracle_compute_unit_in_gbs",
JSON_EXTRACT(properties, '$.openMode') as "open_mode",
JSON_EXTRACT(properties, '$.operationsInsightsStatus') as "operations_insights_status",
JSON_EXTRACT(properties, '$.permissionLevel') as "permission_level",
JSON_EXTRACT(properties, '$.privateEndpoint') as "private_endpoint",
JSON_EXTRACT(properties, '$.provisionableCpus') as "provisionable_cpus",
JSON_EXTRACT(properties, '$.role') as "role",
JSON_EXTRACT(properties, '$.serviceConsoleUrl') as "service_console_url",
JSON_EXTRACT(properties, '$.sqlWebDeveloperUrl') as "sql_web_developer_url",
JSON_EXTRACT(properties, '$.supportedRegionsToCloneTo') as "supported_regions_to_clone_to",
JSON_EXTRACT(properties, '$.timeDataGuardRoleChanged') as "time_data_guard_role_changed",
JSON_EXTRACT(properties, '$.timeDeletionOfFreeAutonomousDatabase') as "time_deletion_of_free_autonomous_database",
JSON_EXTRACT(properties, '$.timeLocalDataGuardEnabled') as "time_local_data_guard_enabled",
JSON_EXTRACT(properties, '$.timeOfLastFailover') as "time_of_last_failover",
JSON_EXTRACT(properties, '$.timeOfLastRefresh') as "time_of_last_refresh",
JSON_EXTRACT(properties, '$.timeOfLastRefreshPoint') as "time_of_last_refresh_point",
JSON_EXTRACT(properties, '$.timeOfLastSwitchover') as "time_of_last_switchover",
JSON_EXTRACT(properties, '$.timeReclamationOfFreeAutonomousDatabase') as "time_reclamation_of_free_autonomous_database",
JSON_EXTRACT(properties, '$.usedDataStorageSizeInGbs') as "used_data_storage_size_in_gbs",
JSON_EXTRACT(properties, '$.usedDataStorageSizeInTbs') as "used_data_storage_size_in_tbs",
JSON_EXTRACT(properties, '$.ocid') as "ocid",
JSON_EXTRACT(properties, '$.backupRetentionPeriodInDays') as "backup_retention_period_in_days",
JSON_EXTRACT(properties, '$.whitelistedIps') as "whitelisted_ips",
subscriptionId,
resourceGroupName,
autonomousdatabasename
FROM azure_isv.oracle.autonomous_databases
WHERE subscriptionId = 'replace-me';