(sedona) branch master updated: chore: [CI] Fix snowflake tester workflow (#2600)

[jiayu]

This is an automated email from the ASF dual-hosted git repository.

jiayu pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/sedona.git


The following commit(s) were added to refs/heads/master by this push:
     new dfe75ded21 chore: [CI] Fix snowflake tester workflow (#2600)
dfe75ded21 is described below

commit dfe75ded219606652b48bc650e9af6df7f90351b
Author: Jia Yu <ji...@apache.org>
AuthorDate: Wed Jan 21 23:10:35 2026 -0700

    chore: [CI] Fix snowflake tester workflow (#2600)
    
    Co-authored-by: Kristin Cowalcijk <b...@wherobots.com>
---
 snowflake-tester/pom.xml                                       |  2 +-
 .../java/org/apache/sedona/snowflake/snowsql/SnowClient.java   | 10 ++++------
 2 files changed, 5 insertions(+), 7 deletions(-)

diff --git a/snowflake-tester/pom.xml b/snowflake-tester/pom.xml
index b407af4493..e6753ebf55 100644
--- a/snowflake-tester/pom.xml
+++ b/snowflake-tester/pom.xml
@@ -53,7 +53,7 @@
         <dependency>
             <groupId>net.snowflake</groupId>
             <artifactId>snowflake-jdbc</artifactId>
-            <version>3.23.1</version>
+            <version>3.28.0</version>
         </dependency>
     </dependencies>
 </project>
diff --git 
a/snowflake-tester/src/test/java/org/apache/sedona/snowflake/snowsql/SnowClient.java
 
b/snowflake-tester/src/test/java/org/apache/sedona/snowflake/snowsql/SnowClient.java
index 51a1efd14a..a8b22f33d6 100644
--- 
a/snowflake-tester/src/test/java/org/apache/sedona/snowflake/snowsql/SnowClient.java
+++ 
b/snowflake-tester/src/test/java/org/apache/sedona/snowflake/snowsql/SnowClient.java
@@ -89,12 +89,10 @@ public class SnowClient {
 
   public static SnowClient newFromEnv() throws SQLException {
     Properties prop = new Properties();
-    // check auth method
-    String authMethod = System.getenv("SNOWFLAKE_AUTH_METHOD");
-    if (authMethod.equals("BASIC")) {
-      prop.put("user", System.getenv("SNOWFLAKE_USER"));
-      prop.put("password", System.getenv("SNOWFLAKE_PASSWORD"));
-    }
+    // Use PAT (Programmatic Access Token) authentication
+    prop.put("user", System.getenv("SNOWFLAKE_USER"));
+    prop.put("authenticator", "programmatic_access_token");
+    prop.put("token", System.getenv("SNOWFLAKE_PASSWORD"));
     prop.put("schema", System.getenv("SNOWFLAKE_SCHEMA"));
     prop.put("warehouse", System.getenv("SNOWFLAKE_WAREHOUSE"));
     prop.put("role", System.getenv("SNOWFLAKE_ROLE"));