This is an automated email from the ASF dual-hosted git repository. jiayu pushed a commit to branch fix-snowflake-tester in repository https://gitbox.apache.org/repos/asf/sedona.git
commit 6885e1cf8974d4358c260d5aea3e45e3300f1214 Author: Kristin Cowalcijk <[email protected]> AuthorDate: Thu Jan 22 08:57:54 2026 +0800 chore: [CI] Fix snowflake tester workflow (#570) - Yes, I have read the [Contributor Rules](https://sedona.apache.org/latest/community/rule/) and [Contributor Development Guide](https://sedona.apache.org/latest/community/develop/) - No: - this is a CI update. The PR name follows the format `[CI] my subject` Specify the `distribution` property to resolve the error: `Error: Input required and not supplied: distribution`. Passing snowflake tests - No, this PR does not affect any public API so no need to change the documentation. --------- Co-authored-by: Jia Yu <[email protected]> --- 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"));
