turbot/oci_insights

Query: nosql_table_column

Usage

powerpipe query oci_insights.query.nosql_table_column

Steampipe Tables

SQL

select
c ->> 'name' as "Name",
c ->> 'defaultValue' as "Default Value",
c ->> 'isNullable' as "Nullable",
c ->> 'type' as "Type"
from
oci_nosql_table,
jsonb_array_elements(schema -> 'columns') as c
where
id = $1;

Dashboards

The query is used in the dashboards: