Apr 19, 2024

Access requests — suggested grants

When a request is opened and doesn't include any proposed grants yet, a "Suggestions" button now appears, allowing you to quickly grant access roles to a user's existing functional roles.

These suggestions are based on: the requester's email, so we can find their Snowflake user and existing functional roles; and the request's title and description, so we can determine which tables or schemas they're requesting access to.

Weekly reports — straight to your inbox

Spyglass now sends a weekly report (every Wednesday) that summarizes activity in your account for the last 7 days. It includes information about merged access requests, open access requests, and triggered alerts.

In the future, we'll include information about recommendations specific to your account, as well as any anomalous activity worthy of note.

Explorer — comment on objects

Users can now add comments to object details pages (database, schemas, tables, users, or roles). This is a first feature as part of a larger effort to provide a wiki-style experience to documenting Snowflake objects.

If you have a collaborative metadata use case you're looking to fill, reach out and let us know!

User experience

• Added a better animated indication to the Snowflake settings page when automatic sync is enabled.

• Functional roles summary table now displays a user count for each role, with a tooltip that lists their usernames.

• Fixed a formatting issue with the metadata sidebar on the access requests detail page.