snowflake-install-auth

name	snowflake-install-auth
description	Install and configure Snowflake driver authentication for Node.js and Python. Use when setting up snowflake-sdk, snowflake-connector-python, key pair auth, OAuth, or SSO browser authentication. Trigger with phrases like "install snowflake", "setup snowflake", "snowflake auth", "snowflake connection", "snowflake key pair".
allowed-tools	Read, Write, Edit, Bash(npm:*), Bash(pip:*), Bash(openssl:*), Grep
version	1.5.0
license	MIT
author	Jeremy Longshore <[e-mail]>
tags	["saas","data-warehouse","analytics","snowflake"]
compatibility	Designed for Claude Code

Snowflake Install & Auth

Overview

Set up Snowflake drivers and configure authentication for Node.js (snowflake-sdk) and Python (snowflake-connector-python).

Prerequisites

• Node.js 18+ or Python 3.9+
• Snowflake account (format: <orgname>-<account_name> or legacy <account_locator>.<region>)
• User with appropriate role granted

Instructions

Step 1: Install the Driver

# Node.js — official driver from snowflakedb
npm install snowflake-sdk

# Python — official connector
pip install snowflake-connector-python

# Python with pandas support
pip install "snowflake-connector-python[pandas]"

Step 2: Choose an Authentication Method

Method	Use Case	Env Vars Needed
Password	Quick dev setup	SNOWFLAKE_ACCOUNT, SNOWFLAKE_USER, SNOWFLAKE_PASSWORD
Key Pair	CI/CD, service accounts	SNOWFLAKE_ACCOUNT, SNOWFLAKE_USER, SNOWFLAKE_PRIVATE_KEY_PATH
External Browser SSO	Interactive dev	SNOWFLAKE_ACCOUNT, SNOWFLAKE_USER
OAuth	Enterprise SSO integration	SNOWFLAKE_ACCOUNT, SNOWFLAKE_OAUTH_TOKEN

Step 3a: Password Authentication

// src/snowflake/client.ts
import snowflake from 'snowflake-sdk';

const connection = snowflake.createConnection({
  account: process.env.SNOWFLAKE_ACCOUNT!,   // e.g. 'myorg-myaccount'
  username: process..!,
  : process..!,
  : process.. || ,
  : process..,
  : process.. || ,
  : process.. || ,
});

connection.( {
   (err) {
    .(, err.);
    ;
  }
  .(, conn.());
});