# Request Snowflake Access with SnowTower

New Snowflake users need clear steps for access, keys, and first connections. This skill guides Claude, Codex, and Claude Code through SnowTower onboarding and common fixes.

## Install

```bash
npx skillstore add database-tycoon/snowtower-user
```

## Metadata

- Status: approved
- Slug: database-tycoon-snowtower-user
- Skillstore revision: r1
- Version status: missing
- Tree hash: 7e50286a19dde5bf26cabb73dc56e1bea93ef33230433fe8db47e4a49b17b136
- Author: Database-Tycoon
- GitHub username: Database-Tycoon
- License: MIT
- Repository: https://github.com/Database-Tycoon/SnowTower/tree/main/.claude/skills/snowtower-user
- Ref: 7db9b9f06e0ab79c575b58bc48c4d8dc9849f424
- Supported tools: Claude, Codex, Claude Code
- Audit status: complete
- Agent install advisory: allowed
- Manual install advisory: allowed
- Artifact signature: available
- Audit attestation: unavailable
- Human verification: not\_verified
- Risk factors: external\_commands, filesystem, env\_access
- Quality score: 79
- Quality tier: bronze
- Public page: https://skillstore.pages.dev/skills/database-tycoon-snowtower-user
- Manifest: https://skillstore.pages.dev/api/skills/database-tycoon-snowtower-user/manifest

## Capabilities

- Explains the three-step SnowTower access request flow.
- Guides users through RSA public and private key generation for Snowflake.
- Shows connection examples for Snow CLI, Python, and the Snowflake web interface.
- Describes default roles, warehouses, and personal databases after approval.
- Provides troubleshooting steps for authentication, privileges, and warehouse state.

## Use Cases

- Onboard a new analyst: Walk a new data analyst through key generation, access request submission, and first Snowflake login.
- Connect a script to Snowflake: Help an engineer choose RSA key authentication and configure Snow CLI or Python connector settings.
- Resolve first-login issues: Guide a user through common Snowflake authentication, role, privilege, and warehouse troubleshooting steps.

## Prompt Templates

### Start my Snowflake access request

```
I need Snowflake access through SnowTower. Walk me through what I need to do before I submit the request.
```

### Generate and submit my public key

```
Help me generate the RSA key pair for Snowflake and identify exactly which public key text I should include in my access request.
```

### Connect after approval

```
My SnowTower access was approved. Show me how to connect with Snow CLI and verify my current user, role, and warehouse.
```

### Troubleshoot authentication and privileges

```
I cannot connect to Snowflake or I get insufficient privileges. Help me diagnose key permissions, account settings, role selection, and access gaps.
```

## Limitations

- Does not approve access or modify Snowflake permissions.
- Requires users to follow their organization’s GitHub issue workflow.
- Uses placeholder account, role, and warehouse names that must be replaced.
- Does not validate local key files or network connectivity automatically.

## Best Practices

- Paste only the public key into access requests, never the private key.
- Replace every placeholder account, role, warehouse, and username before connecting.
- Start with a simple current-user query before running larger workloads.

## Anti Patterns

- Do not share the private RSA key in tickets, chat, or prompts.
- Do not use the web UI password for scripts or automated jobs.
- Do not request broad data access without a clear business justification.

## Security Audit

- Audited at: 2026-07-09T01:40:43.867\+00:00
- Summary: Static analysis flagged many security patterns, but review found they are legitimate documentation examples for Snowflake onboarding. The skill does not contain prompt injection, secret exfiltration, hidden execution, or instructions to share private keys.

## Stats

- Views: 278
- Downloads: 7
- Favorites: 0
- Popularity score: 0