snowquery

1.3.0

SQL Interface to 'Snowflake', 'Redshift', 'Postgres', 'SQLite', and 'DuckDB'

0packages depend

5.6Kdownloads / year

–test coverage

13/13checks pass

Overview

About

Maintained by Dani MermelsteinFirst published 2023-07-135 releasesCRAN page ↗GitHub ↗

Run 'SQL' queries across 'Snowflake', 'Amazon Redshift', 'PostgreSQL', 'SQLite', and 'DuckDB' from R with a single function. Optionally stream and cache large query results to a local 'DuckDB' database for efficient work with larger-than-memory datasets.

Install

R (CRAN)pak (dev)Ubuntu (r2u)openSUSE (OBS)

install.packages("snowquery", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("mermelstein/snowquery")

Development version from mermelstein/snowquery. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-snowquery

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled.

bspm (used by r2u) also needs make: sudo apt install make

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-snowquery

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed).

Health

CRAN checks

13OK

Slowest check: 2.7 min · r-devel-linux-x86_64-fedora-clang

Code health

None

Tests · ratio 0.00

not tracked

Coverage

100%

Documentation · exports

Dependencies · direct

Check history

OK2026-08-04
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
NOTE2026-08-01
12 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
OK2026-06-09
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-06-08
12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
OK2026-05-24
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Show 4 earlier snapshots

ERROR2026-05-17
12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
OK2026-05-15
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-05-13
12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
OK2026-03-10
14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMEYes · 721 wordsVignettesNopkgdown siteNoNEWSYes · 100% structuredCode of conductNoContributing guideNo

Examples that run: 100%
Documented parameters: 100%
Return-value docs: 100%
References docs: 0%

Downloads

5.6K

CRAN downloads in the past year

Rank #8,261 · ~15/day · ~466/mo

Releases R versions

Daily download trend is not available in this view yet.

16630 days

1.2K90 days

5.6K1 year

Compare downloads with other packages →

Also on111 r2u2 autocran

Repository

GitHub ↗ mermelstein/snowquery

11Stars

1Forks

0Open issues

0Open PRs

3Releases

16Commits

1Contributors

rsnowflakesql

License GPL-3.0 · 16 commits · Last activity 2025-10-20

Stars over time

2024-12-14 · 112026-07-07 · 11

Repository practices

Upstream repositoryBeta

2 development-tooling and community-health practices detected across 2 families in the upstream repository

Checks run against github.com/mermelstein/snowquery on 2026-08-03.

CRAN release process (1)

cran-comments.md

Lint, format, editor (1)

RStudio project

How this is detected·Detection ruleset v1 (2026-07-18)

Dependencies

Declared dependencies

8 external dependencies (excludes base and recommended)

Depends (0)

none

Imports (8)

yaml reticulate RPostgres RSQLite DBI duckdb dplyr dbplyr

LinkingTo (0)

none

Suggests (0)

none

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

Code & Tests

People & History

People (1)

Maintainer (1)

Dani Mermelstein

Author, Maintainer, Copyright holder

Authors (1)

Dani Mermelstein

Author, Maintainer, Copyright holder

Dani Mermelstein

Author, Maintainer, Copyright holder

Package Timeline

5 releases. Pick two to compare their code metrics. R releases are shown for context.

R
R 4.6.0 released · 2026-04-24
1.3.0Latest
2025-09-10 · current release · diff ↗
R
R 4.5.0 released · 2025-04-11
1.2.1
2024-10-02 · diff ↗
1.2.0
2024-05-08 · diff ↗
R
R 4.4.0 released · 2024-04-24
1.0.0
2023-07-20 · diff ↗
0.0.1
2023-07-13
R
R 4.3.0 released · 2023-04-21

Package metadata

First published: 2023-07-13
Total releases: 5 / 3 yrs
License: GPL (>= 3) OSI
Download size: 10 KB
Installed size: not tracked yet
With dependencies: not tracked yet

Report a problem with this page →