How are credentials managed for Snowflake access?

Credentials are managed securely through environment variables like SNOWFLAKE_PASSWORD or SNOWFLAKE_PRIVATE_KEY_PATH, keeping sensitive data out of the query history.

Do I need to install Python dependencies manually?

No, the skill uses 'uvx' to dynamically handle the snowflake-connector-python and tabulate dependencies at runtime.

Does this skill support Snowflake MFA or SSO?

Yes, by setting the authenticator to 'externalbrowser', the skill can initiate a browser-based SSO flow that supports Multi-Factor Authentication (MFA).

Can I use this skill to export large datasets?

Yes, you can use the --format csv option combined with the --no-limit flag to export query results directly to a local file.

Snowflake Query Execution

Name: Snowflake Query Execution
Author: haggler09

byhaggler09

데이터베이스 관리

Executes SQL queries against Snowflake data warehouses with support for multiple authentication methods and flexible output formats.

소개

The Snowflake Query skill empowers Claude to interact directly with your Snowflake data warehouse, facilitating seamless data extraction, schema exploration, and ad-hoc analysis. It provides comprehensive support for modern authentication standards—including password, RSA key-pair, and SSO/OAuth—ensuring secure connectivity within enterprise environments. Whether you need to inspect a table schema, export a dataset to CSV, or run complex analytical queries, this skill manages the Python connector and formatting requirements to deliver results in human-readable tables or machine-ready JSON and CSV formats.

주요 기능

Configurable query limits, timeouts, and warehouse overrides
Supports Password, RSA Key-Pair, and SSO/OAuth (Browser) authentication
Flexible output formats including JSON, ASCII tables, and CSV
0 GitHub stars
Direct execution of inline SQL strings or external .sql files
Automatic dependency management via uvx for the Snowflake Python connector

사용 사례

Perform rapid schema exploration and metadata inspection during development
Automate data extraction tasks and export results to local CSV files
Execute and validate complex analytical queries directly from the CLI environment

소개

주요 기능

Configurable query limits, timeouts, and warehouse overrides
Supports Password, RSA Key-Pair, and SSO/OAuth (Browser) authentication
Flexible output formats including JSON, ASCII tables, and CSV
0 GitHub stars
Direct execution of inline SQL strings or external .sql files
Automatic dependency management via uvx for the Snowflake Python connector

사용 사례

Perform rapid schema exploration and metadata inspection during development
Automate data extraction tasks and export results to local CSV files
Execute and validate complex analytical queries directly from the CLI environment