{ "_id": "6a1f07bcb401979e7341bf4d", "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-05-18 06:40:30 UTC", "User": "root" }, "Author": "Dani Mermelstein [aut, cre, cph]", "MD5sum": "7bbf775e8bf0fd0c34d02a4282bc58ca", "_user": "mermelstein", "_type": "src", "_file": "snowquery_1.3.0.tar.gz", "_fileid": "0d7e62c93e3aa414fc111647ca91c457cfc6c7adc3052d60ee72e6b602b0de91", "_filesize": 92448, "_sha256": "0d7e62c93e3aa414fc111647ca91c457cfc6c7adc3052d60ee72e6b602b0de91", "_created": "2026-05-18T06:40:30.000Z", "_published": "2026-06-02T16:41:32.374Z", "_distro": "noble", "_jobs": [ { "job": 79123104712, "time": 153, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7051104676" }, { "job": 79123104660, "time": 151, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7051104374" }, { "job": 79123104579, "time": 194, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7051106255" }, { "job": 79123104927, "time": 154, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7051099182" }, { "job": 79123104275, "time": 183, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7051067014" }, { "job": 79123103921, "time": 106, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7364054911" }, { "job": 79123104667, "time": 97, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7051091254" }, { "job": 79123104894, "time": 134, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7051100683" }, { "job": 79123104598, "time": 101, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7051092147" } ], "_buildurl": "https://github.com/r-universe/mermelstein/actions/runs/26017637433", "_status": "success", "_host": "GitHub-Actions", "_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" }, "_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-37", "n": 2 }, { "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", "description": "Fun side projects:\r\n\r\nwww.getbloombet.com\r\nwww.betterthanguessing.com\r\nwww.rowhardplan.com" }, "_downloads": { "count": 515, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/snowquery" }, "_devurl": "https://github.com/mermelstein/snowquery", "_searchresults": 3, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "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": 4.041392685158225, "_indexed": true, "_nocasepkg": "snowquery", "_universes": [ "mermelstein" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.3.0", "date": "2026-05-18T06:42:42.000Z", "distro": "noble", "commit": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "fileid": "62ec8fdf71648b7e68cc6fd355a9a0c21508365bb6161d92c88f0fd13e5253ab", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mermelstein/actions/runs/26017637433" }, { "r": "4.6.0", "os": "linux", "version": "1.3.0", "date": "2026-05-18T06:42:42.000Z", "distro": "noble", "commit": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "fileid": "477ccbac44abe64b06da1f98aaf56a45b0412914fa2b637561ae0adfbe41e67b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mermelstein/actions/runs/26017637433" }, { "r": "4.5.3", "os": "mac", "version": "1.3.0", "date": "2026-05-18T06:43:01.000Z", "commit": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "fileid": "4c7939e612c98ed6fd63196bed398f1a1f1b45dac76faa90bf74a4493376367d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mermelstein/actions/runs/26017637433" }, { "r": "4.6.0", "os": "mac", "version": "1.3.0", "date": "2026-05-18T06:42:34.000Z", "commit": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "fileid": "f678861ea29351f9d84e0cdf6937c102110b51e08db4aa37e42fc4c33e5e7844", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mermelstein/actions/runs/26017637433" }, { "r": "4.7.0", "os": "win", "version": "1.3.0", "date": "2026-05-18T06:41:42.000Z", "commit": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "fileid": "9a7d5789124d01e3d7eb72ae88cab34040ccef124d6e443a5bebbe43aa36ea06", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mermelstein/actions/runs/26017637433" }, { "r": "4.5.3", "os": "win", "version": "1.3.0", "date": "2026-05-18T06:42:20.000Z", "commit": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "fileid": "59cc136b750f4d046ef152bd65dae3d6a18f0c76df567712116cb90699db3cb0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mermelstein/actions/runs/26017637433" }, { "r": "4.6.0", "os": "win", "version": "1.3.0", "date": "2026-05-18T06:41:49.000Z", "commit": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "fileid": "a69606304d438d4ef7845c1111ca628aa9cc1606c9ba3b94b16df1615ca3203c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mermelstein/actions/runs/26017637433" }, { "r": "4.6.0", "os": "wasm", "version": "1.3.0", "date": "2026-06-02T16:41:14.000Z", "commit": "0d29af32eb65d3a40b39b88d252f32446d3866e8", "fileid": "0b215112636a3b60e164349887cd0862578db94962f9359cb04504f14c2185ec", "status": "success", "buildurl": "https://github.com/r-universe/mermelstein/actions/runs/26017637433" } ] }