Snowflake SDK not found by runtime despite being installed locally and globally

[altimateanas]

Issue

warehouse_test and sql_execute fail for all Snowflake connections with:

Error: Snowflake driver not installed. Run: npm install snowflake-sdk

However, snowflake-sdk@1.15.0 is confirmed installed both locally and globally:

• Local: /Users/anas/demos/altimate-code-demos/node_modules/snowflake-sdk
• Global: /opt/homebrew/lib/node_modules/snowflake-sdk
• node -e "require('snowflake-sdk')" loads successfully

Environment

• 7 Snowflake connections configured, all fail with same error
• SQL Server driver loads fine (fails on auth, not on driver resolution)
• npm install snowflake-sdk was run during the session — no change

Expected Behavior

The altimate-code runtime should find snowflake-sdk from the project's local node_modules or the global npm path.

Likely Cause

The runtime resolves modules from its own bundled node_modules directory rather than respecting the project-local or global npm paths. The driver detection check may need to use require.resolve() with additional lookup paths, or the runtime needs NODE_PATH set.

Workaround

Users can use altimate-dbt execute to query Snowflake through dbt's own adapter, bypassing the direct warehouse connection.

---

Metadata

Field	Value
CLI Version	0.5.19
Platform	darwin
Architecture	arm64
OS Release	24.3.0
Category	bug
Working Directory	altimate-code-demos
Session ID	ses_28dc56d07ffeu9MUjgw6be4N4x