snowflake-upgrade-migration

# Snowflake Upgrade & Migration ## Overview Guide for upgrading Snowflake driver versions, handling Snowflake behavior change releases, and migrating between editions. ## Prerequisites - Current driver version identified - Test suite available - Staging Snowflake account - Git for version control ## Instructions ### Step 1: Check Current Versions ```bash # Node.js driver npm list snowflake-sdk npm view snowflake-sdk version # Latest available # Python connector pip show snowflake-connector-python pip index versions snowflake-connector-python 2>/dev/null | head -5 # Snowflake platform version (run in SQL) # SELECT CURRENT_VERSION(); ``` ### Step 2: Review Snowflake Release Notes ```bash # Check Node.js driver changelog open https://github.com/snowflakedb/snowflake-connector-nodejs/blob/master/CHANGELOG.md # Check Python connector changelog open https://docs.snowflake.com/en/release-notes/clients-drivers/python-connector-2025 # Check Snowflake BCR (Behavior Change Releases) open https://docs.snowflake.com/en/release-notes/bcr-bundles ``` ### Step 3: Upgrade on a Branch ```bash # Node.js git checkout -b chore/upgrade-snowflake-sdk npm install snowflake-sdk@latest npm test # Python git checkout -b chore/upgrade-snowflake-connector pip install --upgrade snowflake-connector-python pytest ``` ### Step 4: Handle Common Breaking Changes **Node.js Driver Changes (1.x to 2.x+):** ```typescript // Old: Synchronous configure // snowflake.configure({ logLevel: 'DEBUG' }...