Which schema has the RESOURCE_MONITORS view?
Which schema has the RESOURCE_MONITORS view?
The schema that has the RESOURCE_MONITORS view is the READER_ACCOUNT_USAGE schema. This view is available specifically for monitoring resources in reader accounts managed by the account.
https://docs.snowflake.com/en/sql-reference/account-usage/resource_monitors.html
https://docs.snowflake.com/en/sql-reference/account-usage/resource_monitors.html
RESOURCE_MONITORS View: This Account Usage view displays the resource monitors that have been created in the reader accounts managed by the account. Note This view is only available in the READER_ACCOUNT_USAGE schema. https://docs.snowflake.com/en/sql-reference/account-usage/resource_monitors
RESOURCE_MONITORS View This Account Usage view displays the resource monitors that have been created in the reader accounts managed by the account. Note: This view is only available in the READER_ACCOUNT_USAGE schema. REF: https://docs.snowflake.com/en/sql-reference/account-usage/resource_monitors#
redaer account usage
B. READER_ACCOUNT_USAGE
B is Correct
B is correct. https://docs.snowflake.com/en/sql-reference/account-usage/resource_monitors#
correct
This view is only available in the READER_ACCOUNT_USAGE schema.
answer is B
You can execute this : use database SNOWFLAKE; select * from reader_account_usage.resource_monitors
This view is only available in the READER_ACCOUNT_USAGE schema.