spyglass-cli v0.5.6
Manage your Snowflake access controls as code.
š£āāļø Before Spyglass: Permissions are managed manually across scripts, snowsight worksheets, and one-off requests.
š¤ After Spyglass: Permissions are managed centrally in git and automatically synced to Snowflake.
Overview
For a detailed explanation, see our Introducing Snowflake Access-as-Code post.
Basic usage of this tool looks like:
1. Import your current Snowflake objects/roles to YAML.
āāāāāāāāāāāāā spyglass import / sync āāāāāāāāāāāā
ā Snowflake ā āāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāŗ ā YAML ā
āāāāāāāāāāāāā āāāāāāāāāāāā
2. Manage them as code.
āāāāāāāāāāāāā make changes āāāāāāāāāāāā
ā ā āāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāŗ ā ā
ā Data User ā spyglass verify ā YAML ā
ā ā āāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāŗ ā ā
āāāāāāāāāāāāā āāāāāāāāāāāā
3. Automatically sync objects/roles between your Git repo and Snowflake.
āāāāāāāāāāāāā spyglass apply āāāāāāāāāāāā
ā Snowflake ā āāāāāāāāāāāāāāāāāāāāāāāāāāāāāāā ā YAML ā
āāāāāāāāāāāāā āāāāāāāāāāāā
Getting Started
Install the CLI using npm
:
sudo npm install -g spyglass-cli@latest
Basic Usage
See How do I set up the CLI? #43.
See the Reference Documentation for details on the configuration.
CI/CD Usage
See How do I set up github actions / workflows? #42.
Query Usage
For getting insight into "who can access what?", see Announcing Queries (alpha) #45.
Getting Help and Contributing
We love working with the community, here's a few ways to get involved:
- Discussions - For FAQs, Q&A, feature requests, ideas, announcements, and sharing your use cases.
- Issues - For bug reports and concrete work items.
- Email - If all else fails, or if you'd just like to chat, let us know at devs@spyglass.software.
- Slack - For early partners, we're working on Slack for real time feedback and support. If you're interested, reach out to demo@spyglass.software.
Security
For submitting security issues, see SECURITY.md
For our security guidance to users, see Security Best Practices #96
Usage Analytics
We constantly improve this software, but we need your help! By default, we log anonymous analytics such as: commands invoked, errors, and software versions. We never log any personally-identifiable user information.
To opt out, you can run spyglass config:set disableAnalytics true
. See https://github.com/spyglasshq/spyglass-cli/issues/9 and logging.ts for more information.
Roadmap
As of Q1 '23, Spyglass has full support for Snowflake. Support for other analytics databases (BigQuery, Databricks, Redshift, Oracle, etc.) is planned to follow.
Check out the Milestones page to track further progress.
5 months ago
6 months ago
5 months ago
5 months ago
6 months ago
7 months ago
7 months ago
7 months ago
8 months ago
8 months ago
8 months ago
10 months ago
10 months ago
9 months ago
11 months ago
9 months ago
12 months ago
12 months ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago