How do I set up github actions / workflows?

[APTy]

I want to set up spyglass to:

• On merge, apply config from git --> Snowflake
• Periodically sync Snowflake --> git

[spyglass-software]

1. Get the workflows

A. Copy the apply, sync, and apply-dry-run workflows to your repo's .github/workflows/ dir.

B. In all three files, replace YOUR_ACCOUNT_ID_HERE and YOUR_SPYGLASS_DIR_HERE with your Snowflake account ID and location of your spyglass directory. See How do I set up the CLI? for more information on those values.

2. Set up secrets

Go to Settings -> Secrets and variables -> Actions and create a SNOWSQL_CONFIG secret and paste in the contents of your ~/.snowsql/config file (created during initial setup).

3. Validate behavior

A. For apply, you can push to your master/main branch and check the output of the dry run before replacing the --dry-run flag with the --confirm flag.

B. For sync, you can go to the Actions panel and click Run workflow to execute it manually.

It's a good idea to check the git diff in the action is working correctly before enabling the commit steps.

4. Finished!

Now you can sit back, relax, and enjoy the automation!