ts-profile-snowflake

Manage Snowflake connection profiles for Python connector and CLI.

3|7|Updated Apr 23, 2026
One-click install
npx skills add https://github.com/thoughtspot/thoughtspot-agent-skills --skill ts-profile-snowflake
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: ts-profile-snowflake
Source: https://github.com/thoughtspot/thoughtspot-agent-skills/tree/main/agents/claude/ts-profile-snowflake
Command: npx skills add https://github.com/thoughtspot/thoughtspot-agent-skills --skill ts-profile-snowflake

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Managing Snowflake connection profiles across Python connectors and the Snowflake CLI is error-prone and tedious. This skill provides a unified workflow to add, list, update, delete, and test profiles, while securely handling credentials and CLI configuration.

Core Features & Use Cases

  • Multi-method support: create and manage either Python connector profiles (key pair or password) or Snowflake CLI connections.
  • Secure credential storage: passwords are kept in the OS credential store (Keychain/ Credential Manager/ Secret Service) and private keys are stored locally and used securely.
  • CLI integration: writes and validates Snowflake CLI configuration files, enabling seamless CLI-based connections and tests.
  • Use Case: data engineers can onboard new Snowflake connections, verify them, and reuse across data pipelines without re-entering credentials.

Quick Start

Run the interactive setup to configure your first Snowflake profile by selecting Python connector or CLI and following the prompts.

Frequently Asked Questions about ts-profile-snowflake

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I manage Snowflake connection profiles for both Python connector and CLI?

Managing Snowflake connection profiles across Python connectors and the CLI is done through a unified interface that supports adding, listing, updating, deleting, and testing connections. It writes and validates configuration files for seamless CLI integration.

How are Snowflake credentials stored securely across different operating systems?

Snowflake credentials are stored securely using native OS credential stores, including macOS Keychain, Windows Credential Manager, or Linux Secret Service. Private keys for key pair authentication are stored locally and used securely without re-entering passwords.

What do I need to set up Snowflake key pair authentication for my data pipelines?

Setting up Snowflake key pair authentication requires Python 3, the Snowflake connector, and access to OS credential stores. You can configure and verify connections interactively, then reuse them across data pipelines without re-entering credentials.

Can I test Snowflake CLI connections after writing the configuration files?

Yes, you can test Snowflake CLI connections directly after configuration. The workflow validates the CLI configuration files and runs connection tests, ensuring data engineers can verify connectivity before onboarding connections to production environments.

What is the best way to update existing Snowflake profiles without re-entering passwords?

The best way to update existing Snowflake profiles is using a dedicated management workflow that modifies connection settings while keeping credentials in the OS credential store. This prevents re-entering passwords and maintains consistent settings across environments.