snowflake-install-auth

# 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 ```bash # 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 ```typescript // src/snowflake/client.ts import snowflake from 'snowflake-sdk'; const connection = snowflake.createConnection({ account: process.env.SNOWFLAKE_ACCOUNT!, // e.g. 'myorg-myaccount' username: process.env.SNOWFLAKE_USER!, password: process.env.SNOWFLAKE_PASSWORD!, warehouse: process.env.SNOWFLAKE_WAREHOUSE ||...