turbot/snowflake_compliance
GitHub

Query: iam_schema_managed_access_enabled

Usage

steampipe query snowflake_compliance.query.iam_schema_managed_access_enabled

Plugins & Tables

SQL

select
catalog_name || '.' || schema_name as resource,
case
when is_managed_access = 'NO' then 'alarm'
else 'ok'
end as status,
case
when is_managed_access = 'NO' then catalog_name || '.' || schema_name || ' schema managed access is not set.'
else catalog_name || '.' || schema_name || ' schema managed access is set.'
end as reason,
account
from
snowflake_schemata;

Controls

The query is being used by the following controls: