snowflake-hello-world

Featured

Create a minimal working Snowflake example with real SQL queries. Use when testing your Snowflake setup, running first queries, or learning basic snowflake-sdk and snowflake-connector-python patterns. Trigger with phrases like "snowflake hello world", "snowflake example", "snowflake quick start", "first snowflake query".

AI & Automation 2,926 stars 433 forks Updated yesterday MIT

Install

View on GitHub

Quality Score: 99/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# Snowflake Hello World ## Overview Minimal working examples demonstrating core Snowflake operations: connect, query, create objects, load data. ## Prerequisites - Completed `snowflake-install-auth` setup - Valid credentials configured in environment - A warehouse available (e.g., `COMPUTE_WH`) ## Instructions ### Step 1: Connect and Query (Node.js) ```typescript // hello-snowflake.ts import snowflake from 'snowflake-sdk'; const connection = snowflake.createConnection({ account: process.env.SNOWFLAKE_ACCOUNT!, username: process.env.SNOWFLAKE_USER!, password: process.env.SNOWFLAKE_PASSWORD!, warehouse: 'COMPUTE_WH', database: 'DEMO_DB', schema: 'PUBLIC', }); connection.connect((err) => { if (err) { console.error('Connection failed:', err.message); process.exit(1); } console.log('Connected to Snowflake!'); // Run a simple query connection.execute({ sqlText: `SELECT CURRENT_TIMESTAMP() AS now, CURRENT_WAREHOUSE() AS warehouse, CURRENT_DATABASE() AS database, CURRENT_ROLE() AS role`, complete: (err, stmt, rows) => { if (err) { console.error('Query failed:', err.message); return; } console.log('Query result:', rows); connection.destroy((err) => { if (err) console.error('Disconnect error:', err.message); }); }, }); }); ``` ### Step 2: Connect and Query (Python) ```python # hello_snowflake.py import snowflake.connector import os con...

Details

Author
jeremylongshore
Repository
jeremylongshore/claude-code-plugins-plus-skills
Created
1 years ago
Last Updated
yesterday
Language
Python
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category

Data & Documents Listed

snowflake-analyst

Explore, analyze, and load data in Snowflake the way you would local CSV files — list databases/schemas/tables like listing directories, inspect a table's columns, preview or sample rows, profile column statistics, and import generated/local data into a table. Use when a user wants to look at, understand, summarize, pull from, or write to a Snowflake table, warehouse, or database. Trigger on phrases like "what's in my Snowflake", "list the tables", "describe this table", "sample/preview a Snowflake table", "profile the columns", "run a query against Snowflake", "how big is this table", "export a Snowflake table to CSV", or "load/import/upload/write data into Snowflake". Built to stay cheap on large tables — computation is pushed to the warehouse and only small results cross the network.

0 Updated today
Rockfish-Data
Data & Documents Listed

snowflake-analyst

Explore, analyze, and load data in Snowflake the way you would local CSV files — list databases/schemas/tables like listing directories, inspect a table's columns, preview or sample rows, profile column statistics, and import generated/local data into a table. Use when a user wants to look at, understand, summarize, pull from, or write to a Snowflake table, warehouse, or database. Trigger on phrases like "what's in my Snowflake", "list the tables", "describe this table", "sample/preview a Snowflake table", "profile the columns", "run a query against Snowflake", "how big is this table", "export a Snowflake table to CSV", or "load/import/upload/write data into Snowflake". Built to stay cheap on large tables — computation is pushed to the warehouse and only small results cross the network.

0 Updated today
Rockfish-Data
AI & Automation Featured

snowflake-development

Use when writing Snowflake SQL, building data pipelines with Dynamic Tables or Streams/Tasks, using Cortex AI functions, creating Cortex Agents, writing Snowpark Python, configuring dbt for Snowflake, or troubleshooting Snowflake errors.

30,055 Updated yesterday
alirezarezvani