Schemas:

ACCOUNT_USAGE

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).