Access templates

Overview

Access roles are virtual roles created for Snowflake objects according to an access template. These templates allow you to apply consistent SQL commands across all of your functional roles, so that rules remain standardized.

Standard templates

Spyglass provides default templates for accessing your databases, schemas, and other objects.

Templated SQL commands are executed when the Reader access template is granted to a functional role.

Here are three common access templates:

• Admin: provides all privileges to all objects within a database or schema.

• Reader: provides read access to all current (and future) tables and views within a database or schema.

• Editor: Provides write access to all current (and future) tables and views within a database or schema.

For a full list of access templates, see the Functional roles page in the Spyglass app.

Custom templates

Spyglass standard templates are designed to cover most major use cases of data access, by both human and service users. If you have a use case not covered by the available templates, please reach out to your Spyglass account rep and we'll be happy to help!