Everything we've written about Snowflake: connections, SQL patterns, imports, clients, and comparisons.
Connect to Snowflake from Ruby. There is no official Ruby driver, so this covers the realistic paths: ODBC with ruby-odbc, sequel-snowflake, and the SQL REST API, plus the account-identifier trap and the 2025 key-pair authentication change.
Connect to Snowflake from PHP with the official pdo_snowflake driver: building the C extension, the account-identifier DSN trap, key-pair auth after the 2025 password block, parameter binding, warehouse setup, uppercase identifiers, and the errors you actually hit.
Connect to Snowflake from C# with Snowflake.Data: account identifiers, key-pair auth after the password block, running queries, parameters, reading results, and the errors you actually hit.
Connect to Snowflake from Java with the snowflake-jdbc driver: JDBC setup, the account identifier format trap, key-pair authentication after the 2025 password block, named binds, and the errors you actually hit.
Connect to Snowflake from Go with the official gosnowflake driver. Working code for the database/sql interface, the v2 import path, the org-account identifier trap, key-pair (JWT) authentication, and warehouse and pooling configuration.
Connect to Snowflake from Node.js with the official snowflake-sdk driver. Working code for key-pair authentication, the account identifier format, parameter binds, promises vs callbacks, and warehouse setup.
Connect to Snowflake from Python with snowflake-connector-python. Working code for key-pair auth, SSO, query parameters, pandas integration, and the account identifier confusion that breaks most first attempts.
Three ways to import Excel data into Snowflake: convert to CSV and use COPY INTO with a stage, Python with snowflake-connector-python, and Mako. Covers staging, file formats, and Snowpark for direct Excel reading.
Three ways to import JSON data into Snowflake: COPY INTO with stages, direct VARIANT insert, and Mako. Covers file formats, FLATTEN, and extracting nested data.
Four ways to import CSV files into Snowflake: PUT + COPY INTO via SnowSQL, the Snowsight web UI, Python connector, and external stage loads. Includes staging, file format, and error handling tips.