SNOW-1501662 Allow JDBC to handle ZSTD compressed http response streams

[sfc-gh-dbouassida]

Overview

SNOW-1501662

Summary

This PR introduces the integration of the zstd-jni library into Snowflake JDBC.

Key Changes

1. Dependency Addition:

   • Added zstd-jni version 1.5.6-5 as a dependency to support Zstandard compression.
   • Updated relevant POM files (pom.xml, FIPS/pom.xml, thin_public_pom.xml, parent-pom.xml) to include the zstd-jni dependency.

2. Shading and Relocation:

   • Updated the Maven Shade Plugin configuration to relocate com.github.luben.zstd into ${shadeBase}.com.github.luben.zstd.
   • Modified FIPS/pom.xml and pom.xml to include relocation rules for the zstd-jni package.

3. Code Integration:

   • Modified DefaultResultStreamProvider.java to handle streams encoded with Zstandard. The code now checks for the zstd encoding and uses ZstdInputStream for decompression.

4. Script Updates:

   • Updated ci/scripts/check_content.sh and FIPS/scripts/check_content.sh to ignore native library files (.so, .dylib, .dll) located in OS-specific directories (aix, darwin, freebsd, linux, win). This prevents errors during the dependency shading check.

5. Linkage Checker Updates:

   • Removed unnecessary exclusions related to com.github.luben.zstd in linkage-checker-exclusion-rules.xml, as the dependencies are now properly shaded and relocated.

Pre-review self checklist

• PR branch is updated with all the changes from master branch
• The code is correctly formatted (run mvn -P check-style validate)
• New public API is not unnecessary exposed (run mvn verify and inspect target/japicmp/japicmp.html)
• The pull request name is prefixed with SNOW-XXXX:
• Code is in compliance with internal logging requirements

External contributors - please answer these questions before submitting a pull request. Thanks!

1. What GitHub issue is this PR addressing? Make sure that there is an accompanying issue to your PR.

   Fixes #NNNN

2. Fill out the following pre-review checklist:

   • I am adding a new automated test(s) to verify correctness of my new code
   • I am adding new logging messages
   • I am modifying authorization mechanisms
   • I am adding new credentials
   • I am modifying OCSP code
   • I am adding a new dependency or upgrading an existing one
   • I am adding new public/protected component not marked with @SnowflakeJdbcInternalApi (note that public/protected methods/fields in classes marked with this annotation are already internal)

3. Please describe how your code solves the related issue.

   Please write a short description of how your code change solves the related issue.

[github-actions]

All contributors have signed the CLA ✍️ ✅
_{Posted by the CLA Assistant Lite bot.}

[sfc-gh-dbouassida]

I have read the CLA Document and I hereby sign the CLA

[sfc-gh-ioukid]

LGTM!