Back to plugin list
Official
Premium
Oracle
The CloudQuery Oracle plugin extracts Oracle Cloud Infrastructure data and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v7.4.0
Type
Source
Platforms
Date Published
Price per 1M rows
Starting from $15
monthly free quota
1M rows
Oracle Database Autonomous Databases
The oracle_database_autonomous_databases table shows data for Oracle Database Autonomous Databases.
Primary Keys #
Name | Type |
---|---|
compartment_id | utf8 |
id | utf8 |
region | utf8 |
Columns #
Name | Type |
---|---|
actual_used_data_storage_size_in_t_bs | float64 |
allocated_storage_size_in_t_bs | float64 |
apex_details | json |
are_primary_whitelisted_ips_used | bool |
autonomous_container_database_id | utf8 |
autonomous_maintenance_schedule_type | utf8 |
auto_refresh_frequency_in_seconds | int64 |
auto_refresh_point_lag_in_seconds | int64 |
available_upgrade_versions | list<item: utf8, nullable> |
backup_config | json |
backup_retention_period_in_days | int64 |
character_set | utf8 |
compartment_id | utf8 |
compute_count | float64 |
compute_model | utf8 |
connection_strings | json |
connection_urls | json |
cpu_core_count | int64 |
_cq_id | uuid |
_cq_parent_id | uuid |
customer_contacts | json |
database_edition | utf8 |
database_management_status | utf8 |
dataguard_region_type | utf8 |
data_safe_status | utf8 |
data_storage_size_in_g_bs | int64 |
data_storage_size_in_t_bs | int64 |
db_name | utf8 |
db_tools_details | json |
db_version | utf8 |
db_workload | utf8 |
defined_tags | json |
disaster_recovery_region_type | utf8 |
display_name | utf8 |
failed_data_recovery_in_seconds | int64 |
freeform_tags | json |
id | utf8 |
infrastructure_type | utf8 |
in_memory_area_in_g_bs | int64 |
in_memory_percentage | int64 |
is_access_control_enabled | bool |
is_auto_scaling_enabled | bool |
is_auto_scaling_for_storage_enabled | bool |
is_data_guard_enabled | bool |
is_dedicated | bool |
is_dev_tier | bool |
is_free_tier | bool |
is_local_data_guard_enabled | bool |
is_mtls_connection_required | bool |
is_preview | bool |
is_reconnect_clone_enabled | bool |
is_refreshable_clone | bool |
is_remote_data_guard_enabled | bool |
key_history_entry | json |
key_store_id | utf8 |
key_store_wallet_name | utf8 |
kms_key_id | utf8 |
kms_key_lifecycle_details | utf8 |
kms_key_version_id | utf8 |
license_model | utf8 |
lifecycle_details | utf8 |
lifecycle_state | utf8 |
local_adg_auto_failover_max_data_loss_limit | int64 |
local_disaster_recovery_type | utf8 |
local_standby_db | json |
long_term_backup_schedule | json |
memory_per_oracle_compute_unit_in_g_bs | int64 |
ncharacter_set | utf8 |
net_services_architecture | utf8 |
next_long_term_backup_time_stamp | timestamp[us, tz=UTC] |
nsg_ids | list<item: utf8, nullable> |
ocpu_count | float64 |
open_mode | utf8 |
operations_insights_status | utf8 |
peer_db_ids | list<item: utf8, nullable> |
permission_level | utf8 |
private_endpoint | utf8 |
private_endpoint_ip | utf8 |
private_endpoint_label | utf8 |
provisionable_cpus | list<item: float64, nullable> |
refreshable_mode | utf8 |
refreshable_status | utf8 |
region | utf8 |
remote_disaster_recovery_configuration | json |
resource_pool_leader_id | utf8 |
resource_pool_summary | json |
role | utf8 |
scheduled_operations | json |
service_console_url | utf8 |
source_id | utf8 |
standby_db | json |
standby_whitelisted_ips | list<item: utf8, nullable> |
subnet_id | utf8 |
supported_regions_to_clone_to | list<item: utf8, nullable> |
system_tags | json |
time_created | timestamp[us, tz=UTC] |
time_data_guard_role_changed | timestamp[us, tz=UTC] |
time_deletion_of_free_autonomous_database | timestamp[us, tz=UTC] |
time_disaster_recovery_role_changed | timestamp[us, tz=UTC] |
time_local_data_guard_enabled | timestamp[us, tz=UTC] |
time_maintenance_begin | timestamp[us, tz=UTC] |
time_maintenance_end | timestamp[us, tz=UTC] |
time_of_auto_refresh_start | timestamp[us, tz=UTC] |
time_of_joining_resource_pool | timestamp[us, tz=UTC] |
time_of_last_failover | timestamp[us, tz=UTC] |
time_of_last_refresh | timestamp[us, tz=UTC] |
time_of_last_refresh_point | timestamp[us, tz=UTC] |
time_of_last_switchover | timestamp[us, tz=UTC] |
time_of_next_refresh | timestamp[us, tz=UTC] |
time_reclamation_of_free_autonomous_database | timestamp[us, tz=UTC] |
time_until_reconnect_clone_enabled | timestamp[us, tz=UTC] |
total_backup_storage_size_in_g_bs | float64 |
used_data_storage_size_in_g_bs | int64 |
used_data_storage_size_in_t_bs | int64 |
vault_id | utf8 |
whitelisted_ips | list<item: utf8, nullable> |