{ "_id": "6aa90226089bafb098cfaf3c", "Package": "snowquery", "Title": "SQL Interface to 'Snowflake', 'Redshift', 'Postgres', 'SQLite',\nand 'DuckDB'", "Version": "1.3.0", "Authors@R": "person(\"Dani\", \"Mermelstein\", , \"dmermelstein@hey.com\", role = c(\"aut\", \"cre\", \"cph\"))", "Maintainer": "Dani Mermelstein ", "Description": "Run 'SQL' queries across 'Snowflake', 'Amazon Redshift',\n'PostgreSQL', 'SQLite', and 'DuckDB' from R with a single\nfunction. Optionally stream and cache large query results to a\nlocal 'DuckDB' database for efficient work with\nlarger-than-memory datasets.", "URL": "https://github.com/mermelstein/snowquery", "BugReports": "https://github.com/mermelstein/snowquery/issues", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.3", "License": "GPL (>= 3)", "Config/pak/sysreqs": "libicu-dev libpng-dev libpq-dev python3 xz-utils", "Repository": "https://mermelstein.r-universe.dev", "Date/Publication": "2025-10-20 01:28:42 UTC", "RemoteUrl": "https://github.com/mermelstein/snowquery", "RemoteRef": "HEAD", "RemoteSha": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "NeedsCompilation": "no", "Packaged": { "Date": "2026-09-15 08:10:13 UTC", "User": "root" }, "Author": "Dani Mermelstein [aut, cre, cph]", "_user": "mermelstein", "_type": "src", "_file": "snowquery_1.3.0.tar.gz", "_fileid": "https://r2.ropensci.org/e8dcf21da72ace79d4c1d26d6b90ce1e93d60e94840a5283062f00bfa98f7d61", "_filesize": 172793, "_sha256": "e8dcf21da72ace79d4c1d26d6b90ce1e93d60e94840a5283062f00bfa98f7d61", "_expires": "2026-12-24T08:30:28.000Z", "_created": "2026-09-15T08:10:13.000Z", "_published": "2026-09-15T08:30:30.494Z", "_jobs": [ { "job": 104303895009, "time": 154, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10387306697" }, { "job": 104303895067, "time": 179, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10387440715" }, { "job": 104303895100, "time": 201, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "10387013425" }, { "job": 104303895061, "time": 162, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "10387678414" }, { "job": 104302818637, "time": 217, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "10387610416" }, { "job": 104303894996, "time": 110, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "10386897623" }, { "job": 104303895023, "time": 95, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10387126313" }, { "job": 104303895032, "time": 93, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "10387360663" }, { "job": 104303895229, "time": 100, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10387735354" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/mermelstein/actions/runs/34945166645", "_status": "success", "_upstream": "https://github.com/mermelstein/snowquery", "_commit": { "id": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "author": "mermelstein ", "committer": "mermelstein ", "message": "README bloat\n", "time": 1760923722 }, "_maintainer": { "name": "Dani Mermelstein", "email": "dmermelstein@hey.com" }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "yaml", "role": "Imports" }, { "package": "reticulate", "role": "Imports" }, { "package": "RPostgres", "role": "Imports" }, { "package": "RSQLite", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "duckdb", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" } ], "_owner": "mermelstein", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-43", "n": 1 } ], "_tags": [], "_topics": [ "snowflake", "sql" ], "_stars": 11, "_contributors": [ { "user": "mermelstein", "count": 16, "uuid": 21294829 } ], "_userbio": { "uuid": 21294829, "type": "user", "name": "Dani Mermelstein", "followers": 19, "description": "Fun side projects:\r\n\r\nwww.getbloombet.com\r\nwww.betterthanguessing.com\r\nwww.rowhardplan.com" }, "_downloads": { "count": 349, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/snowquery" }, "_devurl": "https://github.com/mermelstein/snowquery", "_searchresults": 3, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/snowquery.html", "manual.pdf" ], "_homeurl": "https://github.com/mermelstein/snowquery", "_realowner": "mermelstein", "_cranurl": true, "_releases": [ { "version": "0.0.1", "date": "2023-07-13" }, { "version": "1.0.0", "date": "2023-07-20" }, { "version": "1.2.0", "date": "2024-05-08" }, { "version": "1.2.1", "date": "2024-10-02" }, { "version": "1.3.0", "date": "2025-09-10" } ], "_exports": [ "queryDB" ], "_help": [ { "page": "dot-cache_query_result", "title": "Cache a remote query result to a local DuckDB database", "topics": [ ".cache_query_result" ] }, { "page": "queryDB", "title": "Query a database", "topics": [ "queryDB" ] } ], "_readme": "https://github.com/mermelstein/snowquery/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "blob", "cachem", "cli", "cpp11", "DBI", "dbplyr", "dplyr", "duckdb", "fastmap", "generics", "glue", "here", "hms", "jsonlite", "lattice", "lifecycle", "lubridate", "magrittr", "Matrix", "memoise", "pillar", "pkgconfig", "png", "purrr", "R6", "rappdirs", "Rcpp", "RcppTOML", "reticulate", "rlang", "RPostgres", "rprojroot", "RSQLite", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "timechange", "utf8", "vctrs", "withr", "yaml" ], "_score": 3.7403626894942437, "_indexed": true, "_nocasepkg": "snowquery", "_universes": [ "mermelstein" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.3.0", "date": "2026-09-15T08:12:28.000Z", "distro": "resolute", "commit": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "fileid": "https://r2.ropensci.org/4756989917bdb254ff2722d317c473306b27c12d56dba5937b7ab4de0a477991", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mermelstein/actions/runs/34945166645" }, { "r": "4.6.1", "os": "linux", "version": "1.3.0", "date": "2026-09-15T08:13:02.000Z", "distro": "resolute", "commit": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "fileid": "https://r2.ropensci.org/d352f501c11f78533f47a0a2153a6b7c1ee2bf3a5e59cb74e42adaa92f573b5a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mermelstein/actions/runs/34945166645" }, { "r": "4.5.3", "os": "mac", "version": "1.3.0", "date": "2026-09-15T08:28:20.000Z", "commit": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "fileid": "https://r2.ropensci.org/4a364eb4c2361bfcba1a4fbf51b5ecf3e25df5e2b15419235c5d2cdc7ee23ff7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mermelstein/actions/runs/34945166645" }, { "r": "4.6.1", "os": "mac", "version": "1.3.0", "date": "2026-09-15T08:29:01.000Z", "commit": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "fileid": "https://r2.ropensci.org/b4dc162ed7e523337ef1b04eefab8848cdaa921e3db7ebf2e9f0d8b74ce760f2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mermelstein/actions/runs/34945166645" }, { "r": "4.6.0", "os": "wasm", "version": "1.3.0", "date": "2026-09-15T08:12:23.000Z", "commit": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "fileid": "https://r2.ropensci.org/8155a74b1f2f6bb5f7f4b8d8b3b5385f2dd79187e79d45406b951480f0d565d3", "status": "success", "buildurl": "https://github.com/r-universe/mermelstein/actions/runs/34945166645" }, { "r": "4.7.0", "os": "win", "version": "1.3.0", "date": "2026-09-15T08:11:24.000Z", "commit": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "fileid": "https://r2.ropensci.org/25730e1a743a4e1dab9305ff4f2464297d6a73f70f9d91ce696b5fd66634ad07", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mermelstein/actions/runs/34945166645" }, { "r": "4.5.3", "os": "win", "version": "1.3.0", "date": "2026-09-15T08:11:22.000Z", "commit": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "fileid": "https://r2.ropensci.org/16cac84dbd15bdf8618a0849b46566f8a0831582e596529bc3d618b0de0ff9b8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mermelstein/actions/runs/34945166645" }, { "r": "4.6.1", "os": "win", "version": "1.3.0", "date": "2026-09-15T08:11:24.000Z", "commit": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "fileid": "https://r2.ropensci.org/ac4e876f9357a86aedc6ba9d7bd4d3a0ddfd47dfaa934b30097bb54b920a4dda", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mermelstein/actions/runs/34945166645" } ] }