Skip to main content 首页 创作者 jeremylongshore claude-code-plugins-plus-skills snowflake-local-dev-loop
snowflake-local-dev-loop Configure Snowflake local development with testing, mocking, and fast iteration.
Use when setting up dev environment, writing tests against Snowflake,
or establishing a fast iteration cycle with SnowSQL and dev warehouses.
Trigger with phrases like "snowflake dev setup", "snowflake local development",
"snowflake dev environment", "develop with snowflake", "snowflake testing".
跳到安装 Skills Marketplace 发现并探索由社区构建的 Agent Skills
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
直接命令不会经过审查 Prompt；运行前请先检查来源。
npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus-skills --skill snowflake-local-dev-loop命令会保持在同一行。复制前请横向滚动并检查完整内容。
想先保存到本地？可下载 SkillsMP 当前能够提供的文件。
下载 Zip 下载中... 同仓库更多 Skills Implement user sign-up and sign-in flows with Clerk.
Use when building authentication UI, customizing sign-in experience,
or implementing OAuth social login.
Trigger with phrases like "clerk sign-in", "clerk sign-up",
"clerk login flow", "clerk OAuth", "clerk social login".
Implement session management and middleware with Clerk.
Use when managing user sessions, configuring route protection,
or implementing token refresh and custom JWT templates.
Trigger with phrases like "clerk session", "clerk middleware",
"clerk route protection", "clerk token", "clerk JWT".
Configure enterprise SSO, role-based access control, and organization management.
Use when implementing SSO integration, configuring role-based permissions,
or setting up organization-level controls.
Trigger with phrases like "clerk SSO", "clerk RBAC",
"clerk enterprise", "clerk roles", "clerk permissions", "clerk organizations".
jeremylongshore
jeremylongshore/claude-code-plugins-plus-skills
打开 GitHub 仓库 name snowflake-local-dev-loop description Configure Snowflake local development with testing, mocking, and fast iteration.
Use when setting up dev environment, writing tests against Snowflake,
or establishing a fast iteration cycle with SnowSQL and dev warehouses.
Trigger with phrases like "snowflake dev setup", "snowflake local development",
"snowflake dev environment", "develop with snowflake", "snowflake testing".
allowed-tools Read, Write, Edit, Bash(npm:*), Bash(pnpm:*), Grep version 1.5.0 license MIT author Jeremy Longshore <jeremy@intentsolutions.io> tags ["saas","data-warehouse","analytics","snowflake"] compatibility Designed for Claude Code
Snowflake Local Dev Loop
Overview
Set up a fast, reproducible local development workflow for Snowflake with separate dev warehouses, mocked tests, and SnowSQL for rapid iteration.
Prerequisites
Completed snowflake-install-auth setup
Node.js 18+ or Python 3.9+
A dedicated dev warehouse (e.g., DEV_WH_XS) with auto-suspend
Instructions
Step 1: Create Dev-Specific Snowflake Objects
CREATE WAREHOUSE IF NOT EXISTS DEV_WH_XS
WAREHOUSE_SIZE = 'XSMALL'
AUTO_SUSPEND = 60
AUTO_RESUME = TRUE
INITIALLY_SUSPENDED = TRUE ;
CREATE DATABASE IF NOT EXISTS DEV_DB;
CREATE SCHEMA IF NOT EXISTS DEV_DB.SANDBOX;
GRANT USAGE ON WAREHOUSE DEV_WH_XS TO ROLE DEV_ROLE;
GRANT ALL ON DATABASE DEV_DB TO ROLE DEV_ROLE;
Step 2: Project Structure
my-snowflake-project/
├── src/
│ ├── snowflake/
│ │ ├── connection.ts # Connection wrapper with connectAsync
│ │ ├── queries.ts # Typed query functions
│ │ └── types.ts # Row type definitions
│ └── index.ts
├── tests/
│ ├── unit/
│ │ └── queries.test.ts # Mocked — no Snowflake needed
│ └── integration/
│ └── snowflake.test.ts # Requires SNOWFLAKE_* env vars
├── sql/
│ ├── migrations/ # Versioned DDL scripts
│ │ ├── V001__create_users.sql
│ │ └── V002__add_orders.sql
│ └── seeds/
│ └── dev-data.sql # Sample data for dev
├── .env.local # Local secrets (git-ignored)
├── .env.example # Template for team
└── package.json
Step 3: Connection Wrapper with Async/Await
import snowflake from 'snowflake-sdk' ;
snowflake.configure ({ logLevel : 'WARN' });
export function createSnowflakeConnection (return snowflake.createConnection ({
account : process.env .SNOWFLAKE_ACCOUNT !,
username : process.env .SNOWFLAKE_USER !,
password : process.env .SNOWFLAKE_PASSWORD !,
warehouse : process.env .SNOWFLAKE_WAREHOUSE || 'DEV_WH_XS' ,
database : process.env .SNOWFLAKE_DATABASE || 'DEV_DB' ,
schema : process.env .SNOWFLAKE_SCHEMA || 'SANDBOX' ,
role : process.env .SNOWFLAKE_ROLE || 'DEV_ROLE' ,
});
}
export function executeQuery (
conn : snowflake.Connection ,
sqlText : string ,
binds ?: any []
): Promise <any []> {
return new Promise ((resolve, reject ) => {
conn.execute ({
sqlText,
binds,
complete : (err, stmt, rows ) => {
if (err) reject (err);
else resolve (rows || []);
},
});
});
}
export function connectAsync (
conn : snowflake.Connection
): Promise <snowflake.Connection > {
return new Promise ((resolve, reject ) => {
conn.connect ((err, conn ) => {
if (err) reject (err);
else resolve (conn);
});
});
}
Step 4: Unit Tests with Mocked Snowflake
import { describe, it, expect, vi, beforeEach } from 'vitest' ;
vi.mock ('snowflake-sdk' , () => ({
default : {
configure : vi.fn (),
createConnection : vi.fn (() => ({
connect : vi.fn ((cb ) => cb (null , { getId : () => 'mock-id' })),
execute : vi.fn (({ sqlText, complete } ) => {
if (sqlText.includes ('CURRENT_WAREHOUSE' )) {
complete (null , {}, [{ WAREHOUSE : 'DEV_WH_XS' }]);
} else if (sqlText.includes ('SELECT' )) {
complete (null , {}, [
{ ID : 1 , NAME : 'Alice' },
{ ID : 2 , NAME : 'Bob' },
]);
} else {
complete (null , { getNumUpdatedRows : () => 1 }, []);
}
}),
destroy : vi.fn ((cb ) => cb (null )),
})),
},
}));
import { createSnowflakeConnection, executeQuery, connectAsync } from '../../src/snowflake/connection' ;
describe ('Snowflake Queries' , () => {
it ('should connect and execute a query' , async () => {
const conn = createSnowflakeConnection ();
await connectAsync (conn);
const rows = await executeQuery (conn, 'SELECT * FROM USERS' );
expect (rows).toHaveLength (2 );
expect (rows[0 ].NAME ).toBe ('Alice' );
});
});
Step 5: Integration Tests (Against Real Snowflake)
import { describe, it, expect, beforeAll, afterAll } from 'vitest' ;
import { createSnowflakeConnection, connectAsync, executeQuery } from '../../src/snowflake/connection' ;
describe.skipIf (!process.env .SNOWFLAKE_ACCOUNT )('Snowflake Integration' , () => {
let conn : any ;
beforeAll (async () => {
conn = createSnowflakeConnection ();
await connectAsync (conn);
await executeQuery (conn, `
CREATE TEMPORARY TABLE test_users (
id INTEGER AUTOINCREMENT, name VARCHAR(100)
)
` );
});
afterAll (async () => {
conn?.destroy (() => {});
});
it ('should insert and query data' , async () => {
await executeQuery (conn,
'INSERT INTO test_users (name) VALUES (?)' , ['TestUser' ]
);
const rows = await executeQuery (conn, 'SELECT * FROM test_users' );
expect (rows.length ).toBeGreaterThan (0 );
expect (rows[0 ].NAME ).toBe ('TestUser' );
});
});
Step 6: SnowSQL for Quick Iteration
brew install --cask snowflake-snowsql
cat >> ~/.snowsql/config << 'EOF'
[connections.dev]
accountname = myorg-myaccount
username = my_user
dbname = DEV_DB
schemaname = SANDBOX
warehousename = DEV_WH_XS
rolename = DEV_ROLE
EOF
snowsql -c dev -q "SELECT COUNT(*) FROM my_table"
snowsql -c dev -f sql/migrations/V001__create_users.sql
Error Handling Error Cause Solution 000606: No active warehouseDev warehouse suspended Set AUTO_RESUME = TRUE on warehouse Module not found: snowflake-sdkNot installed Run npm install snowflake-sdk Tests timeoutWarehouse resuming from suspend Increase test timeout to 30s, or pre-warm 002003: Object does not existWrong database/schema context Check .env.local DB and SCHEMA values
Resources
Next Steps See snowflake-sdk-patterns for production-ready code patterns.
