turbot/snowflake_compliance

Query: iam_schema_managed_access_enabled

Usage

powerpipe query snowflake_compliance.query.iam_schema_managed_access_enabled

Steampipe 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: