In Snowflake JS Stored Procs, ResultSet.getColumnValue() errors when called with a string column name instead of a numeric column index

[aelyataltruist]

LocalStack for Snowflake — bug report

Environment

• LocalStack CLI version: 2026.6.0
• LocalStack container version: 2026.7.0.dev129
• Edition: Pro (Snowflake emulation stack)
• Started via: localstack start --stack snowflake -d
• Client: snowflake-connector-python 3.12.1, Python 3.11
• Connection: host="snowflake.localhost.localstack.cloud", port=4566, account="test", user="test", password="test"

Summary

In a Snowflake JavaScript stored procedure, calling ResultSet.getColumnValue() with a column name (string) throws a TypeError, while calling it with a column index (number) on the same result set works fine. Snowflake's docs describe getColumnValue() as accepting either form interchangeably.

Steps to reproduce

1. Start LocalStack for Snowflake: localstack start --stack snowflake -d
2. Connect with snowflake-connector-python:

   import snowflake.connector
   conn = snowflake.connector.connect(
       user="test", password="test", account="test",
       host="snowflake.localhost.localstack.cloud", port=4566,
   )
   cur = conn.cursor()

3. Index-based access works as expected:

   cur.execute("""
   CREATE OR REPLACE PROCEDURE test_by_index()
   RETURNS VARIANT LANGUAGE JAVASCRIPT EXECUTE AS CALLER
   AS
   $$
     var rs = snowflake.execute({sqlText: "select 42 as FOO"});
     rs.next();
     var v = rs.getColumnValue(1);
     return v;
   $$
   """)
   cur.execute("CALL test_by_index()")
   print(cur.fetchone()[0])  # prints 42

4. The same pattern with name-based access does not:

   cur.execute("""
   CREATE OR REPLACE PROCEDURE test_by_name()
   RETURNS VARIANT LANGUAGE JAVASCRIPT EXECUTE AS CALLER
   AS
   $$
     var rs = snowflake.execute({sqlText: "select 42 as FOO"});
     rs.next();
     var v = rs.getColumnValue('FOO');
     return v;
   $$
   """)
   cur.execute("CALL test_by_name()")
   print(cur.fetchone()[0])

Expected vs. actual

Expected: Step 4 prints 42, same as step 3 — per Snowflake's docs (https://docs.snowflake.com/en/developer-guide/stored-procedure/stored-procedures-api), getColumnValue() should accept a column index or a column name.

Actual: Step 4 raises a ProgrammingError from the JS execution sandbox:

TypeError: Cannot read properties of undefined (reading 'getType')
    at Object.getColumnValue (/tmp/tmpXXXXXXXX:58:39)
    at _userDefinedFunction (/tmp/tmpXXXXXXXX:117:61)
    ...
Node.js v22.23.1

Notes

I checked the Stored Procedures and Feature Coverage docs pages and didn't see this called out as a known limitation, and didn't find a matching existing GitHub issue — happy to provide more detail or a fuller repro if useful.