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

0•

Database Management

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.

Key Features

01Configurable query limits, timeouts, and warehouse overrides

02Supports Password, RSA Key-Pair, and SSO/OAuth (Browser) authentication

03Flexible output formats including JSON, ASCII tables, and CSV

040 GitHub stars

05Direct execution of inline SQL strings or external .sql files

06Automatic dependency management via uvx for the Snowflake Python connector

Use Cases

01Perform rapid schema exploration and metadata inspection during development

02Automate data extraction tasks and export results to local CSV files

03Execute and validate complex analytical queries directly from the CLI environment

Key Features

01Configurable query limits, timeouts, and warehouse overrides

02Supports Password, RSA Key-Pair, and SSO/OAuth (Browser) authentication

03Flexible output formats including JSON, ASCII tables, and CSV

040 GitHub stars

05Direct execution of inline SQL strings or external .sql files

06Automatic dependency management via uvx for the Snowflake Python connector

Use Cases

01Perform rapid schema exploration and metadata inspection during development

02Automate data extraction tasks and export results to local CSV files

03Execute and validate complex analytical queries directly from the CLI environment