Queries in Snowflake

Lists all the account-level (i.e. global) privileges that have been granted to roles.

Lists all the account-level parameters.

Snowflake database is a logical grouping of schemas.

Lists all privileges that have been granted on the database.

This Account Usage view table can be used to query login attempts by Snowflake users within the last 365 days (1 year).

Network policies enable restricting access to your account based on user IP address.

Lists all the resource monitors in your account(s) for which you have access privileges.

An entity to which privileges can be granted. Roles are in turn assigned to users.

Lists all privileges and roles granted to the role.

This Information Schema view displays a row for each schema in the specified (or current) database, including the INFORMATION_SCHEMA schema itself.

This Account Usage view provides information on the session, including information on the authentication method to Snowflake and the Snowflake login event. Snowflake returns one row for each session created over the last year.

A session policy defines the idle session timeout period in minutes and provides the option to override the default idle timeout value of 4 hours.

A user identity recognized by Snowflake, whether associated with a person or program.

Snowflake view is basically a named definition of a query.

Lists view-level privileges that have been granted to roles.

A warehouse, is a cluster of compute resources in Snowflake. Warehouse provides the required resources, such as CPU, memory, and temporary storage, to perform queries.

This Account Usage view can be used to return the hourly credit usage for a single warehouse (or all the warehouses in your account) within the last 365 days (1 year).