steampipe plugin install oci

Table: oci_bds_bds_instance - Query OCI Big Data Service Instances using SQL

Oracle Cloud Infrastructure Big Data Service is a fully managed service that allows you to process large amounts of data at the speed of business. It provides a high-performance, secure, and easy-to-use environment for running big data workloads, including machine learning and artificial intelligence, real-time analytics, and data exploration. The service is fully integrated with Oracle Cloud Infrastructure, providing seamless access to its data and services.

Table Usage Guide

The oci_bds_bds_instance table provides insights into Big Data Service Instances within Oracle Cloud Infrastructure. As a data engineer or data scientist, explore instance-specific details through this table, including the state of the instance, the time it was created, and the shape of nodes. Utilize it to uncover information about instances, such as their network configuration, whether they are in high availability mode, and the type of workload they are designed for.

Examples

Basic info

Explore the configuration details of your Big Data Service instances in Oracle Cloud Infrastructure. This query helps in understanding the current state, security settings, and other crucial details of each instance for better management and decision-making.

select
id,
display_name,
is_high_availability,
is_secure,
is_cloud_sql_configured,
nodes,
number_of_nodes,
cluster_version,
network_config,
cluster_details,
cloud_sql_details,
created_by,
bootstrap_script_url,
kms_key_id,
cluster_profile,
lifecycle_state as state
from
oci_bds_bds_instance;
select
id,
display_name,
is_high_availability,
is_secure,
is_cloud_sql_configured,
nodes,
number_of_nodes,
cluster_version,
network_config,
cluster_details,
cloud_sql_details,
created_by,
bootstrap_script_url,
kms_key_id,
cluster_profile,
lifecycle_state as state
from
oci_bds_bds_instance;

Count the number of nodes per instance

Assess the distribution of nodes across various instances to manage resources more efficiently. This can be particularly useful in optimizing workload distribution and identifying potential bottlenecks.

select
id,
display_name,
number_of_nodes
from
oci_bds_bds_instance;
select
id,
display_name,
number_of_nodes
from
oci_bds_bds_instance;

List secure clusters

Analyze the settings to understand which clusters are secure in your Oracle Cloud Infrastructure Big Data Service. This can be particularly useful for ensuring compliance with security policies and identifying potential vulnerabilities.

select
id,
display_name,
lifecycle_state,
is_secure,
cluster_version,
created_by
from
oci_bds_bds_instance
where
is_secure;
select
id,
display_name,
lifecycle_state,
is_secure,
cluster_version,
created_by
from
oci_bds_bds_instance
where
is_secure = 1;

List highly available clusters

Discover the segments that consist of highly available clusters to ensure your data is always accessible and resilient to failures. This is especially useful in maintaining business continuity and minimizing downtime.

select
id,
display_name,
cluster_profile,
time_created,
lifecycle_state,
is_high_availability,
created_by
from
oci_bds_bds_instance
where
is_high_availability;
select
id,
display_name,
cluster_profile,
time_created,
lifecycle_state,
is_high_availability,
created_by
from
oci_bds_bds_instance
where
is_high_availability;

List clusters that have cloud SQL configured

Determine the areas in which clusters have been configured with Cloud SQL to gain insights into the high availability, security, and lifecycle state of these instances. This can help in assessing the elements within your Oracle Cloud Infrastructure Big Data Service for optimal resource management.

select
id,
cluster_profile,
lifecycle_state,
is_high_availability,
is_secure,
is_cloud_sql_configured
from
oci_bds_bds_instance
where
is_cloud_sql_configured;
select
id,
cluster_profile,
lifecycle_state,
is_high_availability,
is_secure,
is_cloud_sql_configured
from
oci_bds_bds_instance
where
is_cloud_sql_configured = 1;

List cloud SQL details of each cluster

Determine the configuration and settings of each cloud SQL cluster, including details such as shape, IP address, block volume size, and Kerberos mapping. This enables efficient management and monitoring of your cloud SQL clusters.

select
id,
display_name cloud_sql_details ->> 'Shape' as shape,
cloud_sql_details ->> 'ShIpAddressape' as ip_address,
cloud_sql_details ->> 'BlockVolumeSizeInGBs' as block_volume_size_in_gbs,
cloud_sql_details ->> 'IsKerberosMappedToDatabaseUsers' as is_kerberos_mapped_to_database_users,
cloud_sql_details ->> 'KerberosDetails' as kerberos_details
from
oci_bds_bds_instance;
select
id,
display_name,
json_extract(cloud_sql_details, '$.Shape') as shape,
json_extract(cloud_sql_details, '$.ShIpAddressape') as ip_address,
json_extract(cloud_sql_details, '$.BlockVolumeSizeInGBs') as block_volume_size_in_gbs,
json_extract(
cloud_sql_details,
'$.IsKerberosMappedToDatabaseUsers'
) as is_kerberos_mapped_to_database_users,
json_extract(cloud_sql_details, '$.KerberosDetails') as kerberos_details
from
oci_bds_bds_instance;

List network config details of each cluster

Analyze the network configuration of each cluster to understand whether a NAT gateway is required and to pinpoint the specific CIDR block being used. This can be beneficial for assessing network requirements and planning infrastructure changes.

select
id,
network_config ->> 'IsNatGatewayRequired' as nat_gateway_required,
network_config ->> 'CidrBlock' as cidr_block,
from
oci_bds_bds_instance;
select
id,
json_extract(network_config, '$.IsNatGatewayRequired') as nat_gateway_required,
json_extract(network_config, '$.CidrBlock') as cidr_block
from
oci_bds_bds_instance;

List node information of each cluster

Determine the characteristics of each node within your clusters to better understand their configuration and performance. This can be useful for troubleshooting or optimizing your cluster's performance and resource allocation.

select
id,
display_name,
n ->> 'InstanceId' as node_instance_id,
n ->> 'DisplayName' as node_display_name,
n ->> 'LifecycleState' as node_lifecycle_state,
n ->> 'NodeType' as node_type,
n ->> 'Shape' as node_shape,
n ->> 'SubnetId' as node_subnet_id,
n ->> 'IpAddress' as node_ip_address,
n ->> 'SshFingerprint' as node_ssh_fingerprint,
n ->> 'AvailabilityDomain' as node_availability_domain,
n ->> 'FaultDomain' as node_fault_domain,
n ->> 'TimeCreated' as node_time_created,
n ->> 'AttachedBlockVolumes' as node_attached_block_volumes,
n ->> 'Hostname' as node_hostname,
n ->> 'ImageId' as node_image_id,
n ->> 'TimeUpdated' as node_time_updated,
n ->> 'Ocpus' as node_ocpus,
n ->> 'MemoryInGBs' as node_memory_in_gbs,
n ->> 'Nvmes' as node_nvmes,
n ->> 'LocalDisksTotalSizeInGBs' as node_local_disks_total_size_in_gbs
from
oci_bds_bds_instance,
jsonb_array_elements(nodes) as n;
select
id,
display_name,
json_extract(n.value, '$.InstanceId') as node_instance_id,
json_extract(n.value, '$.DisplayName') as node_display_name,
json_extract(n.value, '$.LifecycleState') as node_lifecycle_state,
json_extract(n.value, '$.NodeType') as node_type,
json_extract(n.value, '$.Shape') as node_shape,
json_extract(n.value, '$.SubnetId') as node_subnet_id,
json_extract(n.value, '$.IpAddress') as node_ip_address,
json_extract(n.value, '$.SshFingerprint') as node_ssh_fingerprint,
json_extract(n.value, '$.AvailabilityDomain') as node_availability_domain,
json_extract(n.value, '$.FaultDomain') as node_fault_domain,
json_extract(n.value, '$.TimeCreated') as node_time_created,
json_extract(n.value, '$.AttachedBlockVolumes') as node_attached_block_volumes,
json_extract(n.value, '$.Hostname') as node_hostname,
json_extract(n.value, '$.ImageId') as node_image_id,
json_extract(n.value, '$.TimeUpdated') as node_time_updated,
json_extract(n.value, '$.Ocpus') as node_ocpus,
json_extract(n.value, '$.MemoryInGBs') as node_memory_in_gbs,
json_extract(n.value, '$.Nvmes') as node_nvmes,
json_extract(n.value, '$.LocalDisksTotalSizeInGBs') as node_local_disks_total_size_in_gbs
from
oci_bds_bds_instance,
json_each(nodes) as n;

List KMS key details of each cluster

Explore which clusters are associated with specific KMS keys to understand their protection mode and management details. This is useful for assessing the security configuration of each cluster.

select
i.display_name,
i.kms_key_id,
k.vault_id,
k.management_endpoint,
k.algorithm,
k.current_key_version,
k.protection_mode
from
oci_bds_bds_instance as i,
oci_kms_key as k
where
i.kms_key_id = k.id;
select
i.display_name,
i.kms_key_id,
k.vault_id,
k.management_endpoint,
k.algorithm,
k.current_key_version,
k.protection_mode
from
oci_bds_bds_instance as i
join oci_kms_key as k on i.kms_key_id = k.id;

Schema for oci_bds_bds_instance

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
bootstrap_script_urltextPre-authenticated URL of the bootstrap script in Object Store that can be downloaded and executed.
cloud_sql_detailsjsonbThe information about added Cloud SQL capability.
cluster_detailsjsonbSpecific info about a Hadoop cluster.
cluster_profiletextProfile of the Big Data Service cluster.
cluster_versiontextVersion of the Hadoop distribution.
compartment_idtext=The OCID of the compartment in Tenant in which the resource is located.
created_bytextThe user who created the cluster.
defined_tagsjsonbDefined tags for this resource. Each key is predefined and scoped to a namespace.
display_nametext=The name of the cluster.
freeform_tagsjsonbSimple key-value pair that is applied without any predefined name, type, or scope.
idtext=The OCID of the Big Data Service resource.
is_cloud_sql_configuredbooleanBoolean flag specifying whether or not Cloud SQL should be configured.
is_high_availabilitybooleanBoolean flag specifying whether or not the cluster is highly available (HA).
is_securebooleanBoolean flag specifying whether or not the cluster should be set up as secure.
kms_key_idtextThe OCID of the Key Management master encryption key.
lifecycle_statetext=The state of the cluster.
network_configjsonbAdditional configuration of the user's network.
nodesjsonbThe list of nodes in the cluster.
number_of_nodesbigintNumber of nodes that form the cluster.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
tagsjsonbA map of tags for the resource.
tenant_idtext=, !=, ~~, ~~*, !~~, !~~*The OCID of the Tenant in which the resource is located.
time_createdtimestamp with time zoneTime that the Big Data Service Instance was created.
time_updatedtimestamp with time zoneTime that the Big Data Service Instance was updated.
titletextTitle of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- oci

You can pass the configuration to the command with the --config argument:

steampipe_export_oci --config '<your_config>' oci_bds_bds_instance