Snowflake Local Dev Loop

Overview

Set up a fast, reproducible local development workflow for Snowflake.

Prerequisites

• Completed snowflake-install-auth setup
• Node.js 18+ with npm/pnpm
• Code editor with TypeScript support
• Git for version control

Instructions

Step 1: Create Project Structure

my-snowflake-project/
├── src/
│   ├── snowflake/
│   │   ├── client.ts       # Snowflake client wrapper
│   │   ├── config.ts       # Configuration management
│   │   └── utils.ts        # Helper functions
│   └── index.ts
├── tests/
│   └── snowflake.test.ts
├── .env.local              # Local secrets (git-ignored)
├── .env.example            # Template for team
└── package.json

Step 2: Configure Environment

# Copy environment template
cp .env.example .env.local

# Install dependencies
npm install

# Start development server
npm run dev

Step 3: Setup Hot Reload

{
  "scripts": {
    "dev": "tsx watch src/index.ts",
    "test": "vitest",
    "test:watch": "vitest --watch"
  }
}

Step 4: Configure Testing

import { describe, it, expect, vi } from 'vitest';
import { SnowflakeClient } from '../src/snowflake/client';

describe('Snowflake Client', () => {
  it('should initialize with API key', () => {
    const client = new SnowflakeClient({ apiKey: 'test-key' });
    expect(client).toBeDefined();
  });
});

Output

• Working development environment with hot reload
• Configured test suite with mocking
• Environment variable management
• Fast iteration cycle for Snowflake development

Error Handling

Examples

Mock Snowflake Responses

vi.mock('@snowflake/sdk', () => ({
  SnowflakeClient: vi.fn().mockImplementation(() => ({
    // Mock methods here
  })),
}));

Debug Mode

# Enable verbose logging
DEBUG=SNOWFLAKE=* npm run dev

Resources

• Snowflake SDK Reference
• Vitest Documentation
• tsx Documentation

Next Steps

See snowflake-sdk-patterns for production-ready code patterns.