snowflake-client

LOW

maintainer dcelasun 3 votes scanned 2026-09-17 00:27:14.276658

View on AUR

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

Scan history

Scanned at (UTC)	Severity	Rules
2026-09-17 00:27:14	Low	2
2026-09-16 00:03:17	Low	2
2026-09-15 00:25:31	Low	2
2026-09-14 00:27:57	Low	2
2026-09-13 00:19:54	Low	2
2026-09-12 00:25:17	Low	2
2026-09-11 00:19:22	Low	2
2026-09-10 00:22:44	Low	2
2026-09-09 00:04:09	Low	2
2026-09-08 00:18:08	Low	2
2026-09-07 00:30:15	Low	2
2026-09-06 00:17:06	Low	2
2026-09-05 00:16:27	Low	2
2026-09-04 00:03:13	Low	2
2026-09-03 00:15:47	Low	2
2026-09-02 00:02:31	Low	2
2026-09-01 00:11:19	Low	2
2026-08-31 00:19:57	Low	2
2026-08-30 00:04:14	Low	2
2026-08-29 00:29:17	Low	2