steampipe plugin install oci

Table: oci_ai_anomaly_detection_data_asset - Query OCI AI Anomaly Detection Data Assets using SQL

Oracle Cloud Infrastructure's AI Anomaly Detection service enables you to build and deploy machine learning models to detect anomalies in your time series data. The AI Anomaly Detection Data Asset is a resource in this service that represents a data source from which the service can ingest data for training and inference. It supports data sources such as Object Storage and Data Flow.

Table Usage Guide

The oci_ai_anomaly_detection_data_asset table provides insights into the Data Assets within OCI AI Anomaly Detection service. As a Data Scientist or AI Engineer, you can explore data asset-specific details through this table, including data source type, data source details, and associated metadata. Utilize it to uncover information about your data assets, such as the data source they are linked to and the type of data source, assisting you in managing and organizing your AI Anomaly Detection resources.

Examples

Basic info

Explore the basic details of your AI anomaly detection data assets in Oracle Cloud Infrastructure to understand their states and associated projects. This can be useful for auditing and managing your AI resources effectively.

select
id,
display_name,
project_id,
description,
private_endpoint_id,
lifecycle_state as state
from
oci_ai_anomaly_detection_data_asset;
select
id,
display_name,
project_id,
description,
private_endpoint_id,
lifecycle_state as state
from
oci_ai_anomaly_detection_data_asset;

List the data assets created in the last 30 days

Discover the recently created data assets in the last 30 days to keep track of your project's growth and evolution. This allows for timely assessment and review of newly added resources in your project.

select
id,
display_name,
project_id,
description,
private_endpoint_id,
lifecycle_state as state
from
oci_ai_anomaly_detection_data_asset
where
time_created >= now() - interval '30' day;
select
id,
display_name,
project_id,
description,
private_endpoint_id,
lifecycle_state as state
from
oci_ai_anomaly_detection_data_asset
where
time_created >= datetime('now', '-30 day');

List the data assets that are attached to private endpoints

Determine the areas in which data assets are linked to private endpoints. This is useful for understanding the security and accessibility of your data assets within your project.

select
id,
display_name,
project_id,
description,
private_endpoint_id,
lifecycle_state as state
from
oci_ai_anomaly_detection_data_asset
where
private_endpoint_id is not null;
select
id,
display_name,
project_id,
description,
private_endpoint_id,
lifecycle_state as state
from
oci_ai_anomaly_detection_data_asset
where
private_endpoint_id is not null;

List data assets which are not active

Explore which data assets in your AI anomaly detection project are not currently active. This can help manage resources and identify any assets that may need to be reactivated or removed.

select
id,
display_name,
project_id,
description,
private_endpoint_id,
lifecycle_state as state
from
oci_ai_anomaly_detection_data_asset
where
lifecycle_state <> 'ACTIVE';
select
id,
display_name,
project_id,
description,
private_endpoint_id,
lifecycle_state as state
from
oci_ai_anomaly_detection_data_asset
where
lifecycle_state <> 'ACTIVE';

List the project details the data asset is associated to

Discover the connections between data assets and their associated projects. This query can be used to gain insights into the lifecycle of different projects and their corresponding data assets, providing a clear overview of project timelines and their related data assets.

select
d.id as data_asset_id,
d.display_name as data_asset_name,
p.id as project_id,
p.time_created as project_created_time,
p.display_name as project_name,
p.lifecycle_state as project_lifecycle_state
from
oci_ai_anomaly_detection_data_asset as d
left join oci_ai_anomaly_detection_project as p on d.project_id = p.id;
select
d.id as data_asset_id,
d.display_name as data_asset_name,
p.id as project_id,
p.time_created as project_created_time,
p.display_name as project_name,
p.lifecycle_state as project_lifecycle_state
from
oci_ai_anomaly_detection_data_asset as d
left join oci_ai_anomaly_detection_project as p on d.project_id = p.id;

Schema for oci_ai_anomaly_detection_data_asset

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
compartment_idtext=The OCID of the compartment in Tenant in which the resource is located.
defined_tagsjsonbDefined tags for this resource. Each key is predefined and scoped to a namespace.
descriptiontextA short description of the data asset.
display_nametext=A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
freeform_tagsjsonbSimple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only.
idtext=The Unique Oracle ID (OCID) that is immutable on creation.
lifecycle_statetext=The lifecycle state of the Data Asset.
private_endpoint_idtextOCID of Private Endpoint.
project_idtext=The Unique project id which is created at project creation that is immutable on creation.
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 Data Asset was created.
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_ai_anomaly_detection_data_asset