skills.rest
nathankoerschner
nathankoerschnerCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

snowsql

Connect to Snowflake databases and execute SQL queries via SnowSQL CLI.

Updated Jan 22, 2024
Search Tags:#database#connection#sql#query#snowflake#snowsql
One-click install
npx skills add https://github.com/nathankoerschner/dotfiles --skill snowsql
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: snowsql
Source: https://github.com/nathankoerschner/dotfiles/tree/main/agent-skills/_shared-skills/snowsql
Command: npx skills add https://github.com/nathankoerschner/dotfiles --skill snowsql

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill simplifies connecting to Snowflake databases using the SnowSQL command-line client, enabling users to execute SQL queries directly.

Core Features & Use Cases

  • Database Connection: Establishes a connection to a specified Snowflake instance using pre-configured credentials.
  • Query Execution: Allows users to run SQL queries against Snowflake.
  • Use Case: Quickly check the number of active users in your Snowflake data warehouse by running a SHOW USERS; query.

Quick Start

Use the snowsql skill to connect to the 'dev-connection' and list all tables.

Frequently Asked Questions about snowsql

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

FAQPage Schema
How do I execute SQL queries against a Snowflake database using SnowSQL?▼

To execute SQL queries against a Snowflake database, this Skill connects using the SnowSQL CLI tool with pre-configured credentials. It allows data analysts and engineers to perform database operations, schema exploration, and data retrieval tasks directly.

Do I need a configuration file to connect to Snowflake via SnowSQL?▼

Yes, connecting to Snowflake via SnowSQL requires a valid SnowSQL configuration file. This file must contain defined connection profiles that specify your credentials and target Snowflake instance before you can run queries.

What is the best way to check active users in a Snowflake data warehouse?▼

The best way to check active users in a Snowflake data warehouse is by running a SQL query like `SHOW USERS;`. This Skill facilitates that process by establishing the database connection and executing the query through the SnowSQL CLI.

Can I use SnowSQL for schema exploration in a data warehouse?▼

Yes, you can use SnowSQL for schema exploration in a data warehouse. This Skill enables you to connect to Snowflake and run SQL queries to explore database schemas and retrieve data efficiently.

Does SnowSQL work with pre-configured connection profiles?▼

Yes, SnowSQL works with pre-configured connection profiles. This Skill relies on a valid SnowSQL configuration file to establish connections to specified Snowflake instances, enabling direct query execution.

Related Skills

Explore More Data & Analytics Skills→
clawdataclawdata
24

snowflake

Query and manage Snowflake warehouses, schemas, and tables via the snow CLI.

Official
Intermediate
Orvanta-CloudOrvanta-Cloud

write-script-snowflake

Automate writing, previewing, and deploying Snowflake queries with parameter management and S3 streaming.

Official
Intermediate
FunnelEnvyFunnelEnvy
1

codex-qa

Query codebases with Codex CLI for read-only explanations and architecture insights.

Official
Advanced
Eng0AIEng0AI
15

natural-language-postgres-presentation

Convert natural-language queries into SQL for PostgreSQL data retrieval.

Official
Advanced