Skip to content

snowquery

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

v1.3.0 · Sep 10, 2025 · GPL (>= 3)

Description

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.

Downloads

559

Last 30 days

7232nd

1.7K

Last 90 days

4.5K

Last year

Trend: +0.4% (30d vs prior 30d)

CRAN Check Status

14 OK
Show all 14 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang OK
r-devel-linux-x86_64-debian-gcc OK
r-devel-linux-x86_64-fedora-clang OK
r-devel-linux-x86_64-fedora-gcc OK
r-devel-macos-arm64 OK
r-devel-windows-x86_64 OK
r-oldrel-macos-arm64 OK
r-oldrel-macos-x86_64 OK
r-oldrel-windows-x86_64 OK
r-patched-linux-x86_64 OK
r-release-linux-x86_64 OK
r-release-macos-arm64 OK
r-release-macos-x86_64 OK
r-release-windows-x86_64 OK

Check History

OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026

Dependency Network

Dependencies Reverse dependencies yaml reticulate RPostgres RSQLite DBI duckdb dplyr dbplyr snowquery

Version History

new 1.3.0 Mar 10, 2026
updated 1.3.0 ← 1.2.1 diff Sep 9, 2025
updated 1.2.1 ← 1.2.0 diff Oct 1, 2024
updated 1.2.0 ← 1.0.0 diff May 7, 2024
updated 1.0.0 ← 0.0.1 diff Jul 19, 2023
new 0.0.1 Jul 12, 2023