- Schemas:
ROLES View¶
This Account Usage view can be used to query a list of all roles defined in the account. The data is retained for 365 days (1 year).
Columns¶
Column Name |
Data Type |
Description |
|---|---|---|
CREATED_ON |
TIMESTAMP_LTZ |
Date and time (in the UTC time zone) when the role was created. |
DELETED_ON |
TIMESTAMP_LTZ |
Date and time (in the UTC time zone) when the role was deleted. |
NAME |
VARCHAR |
Name of the role. |
COMMENT |
VARCHAR |
Comment for the role. |
Usage Notes¶
Latency for the view may be up to 120 minutes (2 hours).
Internal Snowflake Role for Snowsight¶
The first time Snowsight is accessed in an account, Snowflake creates an internal WORKSHEETS_APP_RL role to support the web interface. This role is used to cache query results in an internal stage in your account. This cached data is encrypted and protected by the key hierarchy for the account. The limited privileges granted to the internal role only allow Snowsight to access the internal stage to store those results. The role cannot list objects in your account or access data in your tables. For more information, see Getting Started With Snowsight.