snowflake-hello-world

# 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...