snowflake-client

maintainer dcelasun · 3 votes · scanned 2026-08-03 00:08:14.047287

LOW

Why flagged The package downloads a signed installer from Snowflake's official domain; the source is legitimate and the build process does not execute untrusted code, despite the non-whitelisted host.

Triggered rules

LOW AI review downgraded a static finding llm_review

The static rules flagged this MEDIUM, but an AI model (qwen/qwen3-235b-a22b-2507) reviewed the full PKGBUILD and judged it LOW (confidence 95%): The package downloads a signed installer from Snowflake's official domain; the source is legitimate and the build process does not execute untrusted code, despite the non-whitelisted host.

1 higher static finding superseded - not the current verdict (shown for transparency)

MEDIUM source=() URL on a non-standard host source_untrusted_domain

One or more source=() URLs point to a host outside the trusted allowlist (github.com, gitlab.com, codeberg.org, pypi.org, …).

PKGBUILD:22 "${pkgname}-${pkgver}.bash::https://sfc-repo.snowflakecomputing.com/snowsql/bootstrap/${_bootstrap}/linux_x86_64/snowsql-${pkgver}-linux_x86_64.bash"

PKGBUILD

1 offending line(s) highlighted

      1# Maintainer: D. Can Celasun <can[at]dcc[dot]im>
    
      2# Co-Maintainer: Ethan Pailes ethan[at]pailes[dot]org
    
      3
    
      4# To be able to verify the gpg signatures run:
    
      5# ```
    
      6# gpg --keyserver hkp://keyserver.ubuntu.com --recv-keys 3C98F63C9292CE02
    
      7# ```
    
      8
    
      9pkgname=snowflake-client
    
      10pkgver=1.5.1
    
      11_bootstrap=1.5
    
      12pkgrel=1
    
      13epoch=1
    
      14pkgdesc="Snowflake Database command line client (snowsql)"
    
      15arch=('x86_64')
    
      16url="http://www.snowflake.net/"
    
      17license=('custom:commercial')
    
      18depends=('gcc-libs' 'unzip'
    
      19         # Needed for libcrypt.so.1
    
      20         'libxcrypt-compat')
    
      21source=(
    
      22    "${pkgname}-${pkgver}.bash::https://sfc-repo.snowflakecomputing.com/snowsql/bootstrap/${_bootstrap}/linux_x86_64/snowsql-${pkgver}-linux_x86_64.bash"
    
      23    "${pkgname}-${pkgver}.bash.sig::https://sfc-repo.snowflakecomputing.com/snowsql/bootstrap/${_bootstrap}/linux_x86_64/snowsql-${pkgver}-linux_x86_64.bash.sig"
    
      24)
    
      25sha256sums=('91f252b87db49fdda57db67ae4dbc8fb96f0bda2a81d92e954f0d262820abe7f'
    
      26            'SKIP')
    
      27validpgpkeys=('6C983AB7AFE2E5951C6C47B13C98F63C9292CE02')
    
      28
    
      29package() {
    
      30  # Stop Snowflake installer from modifying shell profile
    
      31  local tmp="$(mktemp)"
    
      32
    
      33  SNOWSQL_DEST="${pkgdir}" SNOWSQL_LOGIN_SHELL="${tmp}" sh "${pkgname}-${pkgver}.bash"
    
      34
    
      35  install -Dm755 "${pkgdir}/snowsql" "${pkgdir}/usr/bin/snowsql"
    
      36  rm -f "${pkgdir}/snowsql"
    
      37}
    
      38

Changes since previous scan

--- PKGBUILD @ 2026-06-19 19:07
+++ PKGBUILD @ 2026-08-03 00:08
@@ -7,7 +7,7 @@
 # ```
 
 pkgname=snowflake-client
-pkgver=1.5.0
+pkgver=1.5.1
 _bootstrap=1.5
 pkgrel=1
 epoch=1
@@ -22,7 +22,7 @@
     "${pkgname}-${pkgver}.bash::https://sfc-repo.snowflakecomputing.com/snowsql/bootstrap/${_bootstrap}/linux_x86_64/snowsql-${pkgver}-linux_x86_64.bash"
     "${pkgname}-${pkgver}.bash.sig::https://sfc-repo.snowflakecomputing.com/snowsql/bootstrap/${_bootstrap}/linux_x86_64/snowsql-${pkgver}-linux_x86_64.bash.sig"
 )
-sha256sums=('3124e9b642fab946e701e64e72417fa90797a5708156d3d974eeaf9bea4402c3'
+sha256sums=('91f252b87db49fdda57db67ae4dbc8fb96f0bda2a81d92e954f0d262820abe7f'
             'SKIP')
 validpgpkeys=('6C983AB7AFE2E5951C6C47B13C98F63C9292CE02')
 

Scan history

Scanned at (UTC)	Severity	Rules
2026-08-03 00:08:14	LOW	2
2026-08-02 00:16:08	LOW	2
2026-08-01 00:11:18	LOW	2
2026-07-31 00:14:10	LOW	2
2026-07-30 00:17:23	LOW	2
2026-07-29 00:25:53	LOW	2
2026-07-28 00:07:28	LOW	2
2026-07-27 00:24:32	LOW	2
2026-07-26 00:07:32	LOW	2
2026-07-25 00:13:44	LOW	2
2026-07-24 07:27:58	MEDIUM	1
2026-06-19 19:07:35	CLEAN	2
2026-06-18 16:11:54	MEDIUM	1