steampipe plugin install oci

Table: oci_ai_anomaly_detection_project - Query OCI AI Anomaly Detection Projects using SQL

The OCI AI Anomaly Detection service provides a set of tools within Oracle Cloud Infrastructure that allows you to monitor and respond to anomalies in your data. It uses machine learning and statistical algorithms to detect outliers and unexpected patterns in time-series data. This service is particularly useful in identifying potential issues across your applications and infrastructure.

Table Usage Guide

The oci_ai_anomaly_detection_project table provides insights into anomaly detection projects within Oracle Cloud Infrastructure's AI service. As a data scientist or ML engineer, explore project-specific details through this table, including the project's ID, compartment ID, time created, and lifecycle state. Utilize it to manage and monitor your anomaly detection projects, such as tracking the lifecycle state of projects, understanding the distribution of projects across compartments, and retrieving specific project details.

Examples

Basic info

Explore the basic details of anomaly detection projects in your Oracle Cloud Infrastructure. This can help in understanding the state of these projects and their lifecycle.

select
id,
display_name,
description,
lifecycle_state as state
from
oci_ai_anomaly_detection_project;
select
id,
display_name,
description,
lifecycle_state as state
from
oci_ai_anomaly_detection_project;

List the projects created in the last 30 days

Explore which anomaly detection projects have been initiated in the past month. This can help you keep track of recent activities and understand the current focus areas in your organization.

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

List projects which are not active

Explore which AI anomaly detection projects in your OCI environment are not currently active. This could be useful to identify unused resources or potential areas for cost reduction.

select
id,
display_name,
description,
lifecycle_state as state
from
oci_ai_anomaly_detection_project
where
lifecycle_state <> 'ACTIVE';
select
id,
display_name,
description,
lifecycle_state as state
from
oci_ai_anomaly_detection_project
where
lifecycle_state <> 'ACTIVE';

List the models associated to the project

Explore the relationships between various projects and their associated models. This query can be particularly useful in managing and tracking the lifecycle of models within specific projects, providing insights into their creation time and current status.

select
p.id as project_id,
p.display_name as project_name,
m.id as model_id,
m.time_created as model_created_time,
m.display_name as model_name,
m.lifecycle_state as model_lifecycle_state
from
oci_ai_anomaly_detection_project as p
left join oci_ai_anomaly_detection_model as m on p.id = m.project_id;
select
p.id as project_id,
p.display_name as project_name,
m.id as model_id,
m.time_created as model_created_time,
m.display_name as model_name,
m.lifecycle_state as model_lifecycle_state
from
oci_ai_anomaly_detection_project as p
left join oci_ai_anomaly_detection_model as m on p.id = m.project_id;

List the data asset is associated to the project

Explore which data assets are linked to specific projects. This is useful for understanding the distribution and utilization of data assets across different projects.

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

Schema for oci_ai_anomaly_detection_project

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 project.
display_nametext=A user-friendly display name for the resource. It does not have to be unique and can be modified. 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 OCID of the project that is immutable on creation.
lifecycle_statetext=The lifecycle state of the Project.
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 Project 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_project