Bi-directional sync

This page describes the technical details of how Spyglass syncs data between Snowflake and your GitHub repository.

If you're a normal Spyglass user, you'll probably never need to know these implementation details. It is documented here mostly for curious minds.

Snowflake to GitHub

This occurs as an initial import when you first integrate Spyglass. Then periodically (every hour), Spyglass syncs Snowflake configuration back to your GitHub repository.

What gets synced?

• Basic user, role, database, schema, tables, views and warehouse information

• Roles granted to users

• Permissions granted to roles

• Role inheritance

GitHub to Snowflake

Merged pull requests execute commands in Snowflake.

What gets applied?

• Roles granted to users

• Permissions granted to roles

• Role inheritance

For more information on this process, see Make changes.