Query: iam_schema_managed_access_enabled

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;