Package: snowquery 1.3.0

Dani Mermelstein
snowquery: SQL Interface to 'Snowflake', 'Redshift', 'Postgres', 'SQLite', and 'DuckDB'
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.
Authors:
snowquery_1.3.0.tar.gz
snowquery_1.3.0.zip(r-4.7)snowquery_1.3.0.zip(r-4.6)snowquery_1.3.0.zip(r-4.5)
snowquery_1.3.0.tgz(r-4.6-any)snowquery_1.3.0.tgz(r-4.5-any)
snowquery_1.3.0.tar.gz(r-4.7-any)snowquery_1.3.0.tar.gz(r-4.6-any)
snowquery_1.3.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
snowquery/json (API)
NEWS
| # Install 'snowquery' in R: |
| install.packages('snowquery', repos = c('https://mermelstein.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/mermelstein/snowquery/issues
Last updated from:0d29af32eb. Checks:9 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | OK | 153 | ||
| source / vignettes | OK | 183 | ||
| linux-release-x86_64 | OK | 151 | ||
| macos-release-arm64 | OK | 154 | ||
| macos-oldrel-arm64 | OK | 194 | ||
| windows-devel | OK | 97 | ||
| windows-release | OK | 101 | ||
| windows-oldrel | OK | 134 | ||
| wasm-release | OK | 106 |
Exports:queryDB
Dependencies:bitbit64blobcachemclicpp11DBIdbplyrdplyrduckdbfastmapgenericsglueherehmsjsonlitelatticelifecyclelubridatemagrittrMatrixmemoisepillarpkgconfigpngpurrrR6rappdirsRcppRcppTOMLreticulaterlangRPostgresrprojrootRSQLitestringistringrtibbletidyrtidyselecttimechangeutf8vctrswithryaml
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Cache a remote query result to a local DuckDB database | .cache_query_result |
| Query a database | queryDB |