{ "_id": "6a295617732311cd875b17d7", "Package": "quak", "Title": "Query 'Azure Data Lake Storage Gen2' with 'DuckDB'", "Version": "0.1.0", "Authors@R": "person(\"Pedro\", \"Baltazar\", email = \"pedrobtz@gmail.com\",\nrole = c(\"aut\", \"cre\", \"cph\"))", "Description": "Provides convenience utilities for using 'DuckDB' directly\nover datasets stored in 'Azure Data Lake Storage Gen2' (ADLS\nGen2, 'abfss://'). Opens connections configured for\nAzure-backed 'Delta Lake' and 'Parquet' data, registers Azure\ncredentials as 'DuckDB' secrets, and supports optional\nrepository mirrors for restricted networks. Integrates well\nwith 'DBI' for SQL workflows and with 'dplyr' and 'dbplyr' for\nlazy table queries.", "URL": "https://github.com/pedrobtz/quak", "BugReports": "https://github.com/pedrobtz/quak/issues", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.3", "Config/testthat/edition": "3", "Collate": "'options.R' 'conditions.R' 'connection.R' 'cache.R'\n'repositories.R' 'extensions.R' 'azure.R' 'datasets.R'\n'tables.R' 'lake.R' 'delta.R' 'quak-package.R' 'zzz.R'", "Config/pak/sysreqs": "cmake make libuv1-dev libssl-dev xz-utils", "Repository": "https://pedrobtz.r-universe.dev", "Date/Publication": "2026-06-04 20:55:32 UTC", "RemoteUrl": "https://github.com/pedrobtz/quak", "RemoteRef": "HEAD", "RemoteSha": "6a39eb893aad9059537a4a69da47dbca80ba815a", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-10 12:15:12 UTC", "User": "root" }, "Author": "Pedro Baltazar [aut, cre, cph]", "Maintainer": "Pedro Baltazar ", "MD5sum": "e3ccc23dc10daac459bbbcaaadcaee4b", "_user": "pedrobtz", "_type": "src", "_file": "quak_0.1.0.tar.gz", "_fileid": "bc58fc3bb21946dbf12d9986486a8066eb3beaa6d9f07a08de92cc7be24db2a2", "_filesize": 213181, "_sha256": "bc58fc3bb21946dbf12d9986486a8066eb3beaa6d9f07a08de92cc7be24db2a2", "_created": "2026-06-10T12:15:12.000Z", "_published": "2026-06-10T12:18:31.524Z", "_distro": "noble", "_jobs": [ { "job": 80555709691, "time": 156, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7535390590" }, { "job": 80555709892, "time": 161, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7535392535" }, { "job": 80555709865, "time": 95, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7535368066" }, { "job": 80555709670, "time": 117, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7535376269" }, { "job": 80555061904, "time": 199, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7535333320" }, { "job": 80555709582, "time": 109, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7535374002" }, { "job": 80555709707, "time": 129, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7535380488" }, { "job": 80555709728, "time": 96, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7535369131" }, { "job": 80555709646, "time": 87, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7535365478" } ], "_buildurl": "https://github.com/r-universe/pedrobtz/actions/runs/27275320557", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/pedrobtz/quak", "_commit": { "id": "6a39eb893aad9059537a4a69da47dbca80ba815a", "author": "github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>", "committer": "github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>", "message": "Update coverage badge (72.3%)\n", "time": 1780606532 }, "_maintainer": { "name": "Pedro Baltazar", "email": "pedrobtz@gmail.com", "login": "pedrobtz", "description": "\n", "uuid": 2864346 }, "_registered": true, "_dependencies": [ { "package": "cli", "role": "Imports" }, { "package": "curl", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "duckdb", "role": "Imports" }, { "package": "fs", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "tools", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "azr", "version": ">= 0.3.4", "role": "Suggests" }, { "package": "dbplyr", "role": "Suggests" }, { "package": "dplyr", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "tibble", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "pedrobtz", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-23", "n": 5 } ], "_tags": [], "_topics": [ "azure-storage", "duckdb" ], "_stars": 0, "_contributors": [ { "user": "pedrobtz", "count": 3, "uuid": 2864346 } ], "_userbio": { "uuid": 2864346, "type": "user", "name": "Pedro Z" }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/quak" }, "_devurl": "https://github.com/pedrobtz/quak", "_searchresults": 4, "_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/quak.html", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/pedrobtz/quak", "_realowner": "pedrobtz", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2026-06-09" } ], "_exports": [ "az_conn", "az_conn_settings", "az_copy_to", "az_default_scope", "az_delta_files", "az_exists", "az_glimpse", "az_glob", "az_list_secrets", "az_schema", "az_set_chain_secret", "az_set_sp_secret", "az_set_token_secret", "az_tune", "az_write_parquet", "conn_setting", "ext_cache", "ext_cache_path", "ext_dir", "ext_install", "ext_install_local", "ext_is_installed", "ext_list_available", "ext_list_installed", "ext_load", "ext_set_dir", "ext_uninstall", "load_csv", "load_dataset", "load_delta", "load_json", "load_parquet", "quak_options", "repo_set_urls", "repo_urls", "tbl_csv", "tbl_delta", "tbl_json", "tbl_parquet" ], "_help": [ { "page": "az_conn", "title": "Open a DuckDB connection configured for Azure Data Lake Storage Gen2", "topics": [ "az_conn" ] }, { "page": "az_conn_settings", "title": "Get Azure settings from a DuckDB connection", "topics": [ "az_conn_settings" ] }, { "page": "az_copy_to", "title": "Copy data to Azure Data Lake Storage Gen2", "topics": [ "az_copy_to" ] }, { "page": "az_default_scope", "title": "Get the default Azure OAuth scope", "topics": [ "az_default_scope" ] }, { "page": "az_delta_files", "title": "List files in a Delta table on Azure Data Lake Storage Gen2", "topics": [ "az_delta_files" ] }, { "page": "az_exists", "title": "Check whether data exists at an Azure path", "topics": [ "az_exists" ] }, { "page": "az_glimpse", "title": "Preview an Azure dataset", "topics": [ "az_glimpse" ] }, { "page": "az_glob", "title": "List Azure paths matching a glob pattern", "topics": [ "az_glob" ] }, { "page": "az_list_secrets", "title": "List Azure secrets registered in DuckDB", "topics": [ "az_list_secrets" ] }, { "page": "az_schema", "title": "Inspect a dataset schema without collecting data", "topics": [ "az_schema" ] }, { "page": "az_set_chain_secret", "title": "Register an Azure credential-chain secret", "topics": [ "az_set_chain_secret" ] }, { "page": "az_set_sp_secret", "title": "Register an Azure service-principal secret", "topics": [ "az_set_sp_secret" ] }, { "page": "az_set_token_secret", "title": "Register an Azure token secret", "topics": [ "az_set_token_secret" ] }, { "page": "az_tune", "title": "Tune Azure read settings on a DuckDB connection", "topics": [ "az_tune" ] }, { "page": "az_write_parquet", "title": "Write Parquet data to Azure Data Lake Storage Gen2", "topics": [ "az_write_parquet" ] }, { "page": "collect.tbl_az", "title": "Collect an Azure-backed lazy tbl", "topics": [ "collect.tbl_az" ] }, { "page": "conn_setting", "title": "Get or set DuckDB settings", "topics": [ "conn_setting" ] }, { "page": "ext_cache", "title": "Extension cache", "topics": [ "ext_cache" ] }, { "page": "ext_cache_path", "title": "Default DuckDB extension cache directory", "topics": [ "ext_cache_path" ] }, { "page": "ext_dir", "title": "Find the DuckDB extension folder", "topics": [ "ext_dir" ] }, { "page": "ext_install", "title": "Install a DuckDB extension", "topics": [ "ext_install" ] }, { "page": "ext_install_local", "title": "Install a DuckDB extension from a local file", "topics": [ "ext_install_local" ] }, { "page": "ext_is_installed", "title": "Check whether a DuckDB extension is installed", "topics": [ "ext_is_installed" ] }, { "page": "ext_list_available", "title": "List all DuckDB core extensions", "topics": [ "ext_list_available" ] }, { "page": "ext_list_installed", "title": "List installed DuckDB extensions", "topics": [ "ext_list_installed" ] }, { "page": "ext_load", "title": "Load a DuckDB extension, installing it first if necessary", "topics": [ "ext_load" ] }, { "page": "ext_set_dir", "title": "Set the DuckDB extension folder", "topics": [ "ext_set_dir" ] }, { "page": "ext_uninstall", "title": "Uninstall a DuckDB extension", "topics": [ "ext_uninstall" ] }, { "page": "load_csv", "title": "Register a CSV dataset as a view on a DuckDB connection", "topics": [ "load_csv" ] }, { "page": "load_dataset", "title": "Register a Delta, Parquet, CSV, or JSON dataset on a DuckDB connection", "topics": [ "load_dataset" ] }, { "page": "load_delta", "title": "Register a Delta Lake table on a DuckDB connection", "topics": [ "load_delta" ] }, { "page": "load_json", "title": "Register a JSON dataset as a view on a DuckDB connection", "topics": [ "load_json" ] }, { "page": "load_parquet", "title": "Register a Parquet dataset as a view on a DuckDB connection", "topics": [ "load_parquet" ] }, { "page": "print.quak_opts", "title": "Print the quak option registry", "topics": [ "print.quak_opts" ] }, { "page": "quak_options", "title": "List all quak options and their current values", "topics": [ "quak_options" ] }, { "page": "repo_set_urls", "title": "Set DuckDB extension repository URLs", "topics": [ "repo_set_urls" ] }, { "page": "repo_urls", "title": "Get DuckDB extension repository URLs", "topics": [ "repo_urls" ] }, { "page": "tbl_csv", "title": "Open a CSV dataset as a lazy dplyr tbl", "topics": [ "tbl_csv" ] }, { "page": "tbl_delta", "title": "Open a Delta Lake table as a lazy dplyr tbl", "topics": [ "tbl_delta" ] }, { "page": "tbl_json", "title": "Open a JSON dataset as a lazy dplyr tbl", "topics": [ "tbl_json" ] }, { "page": "tbl_parquet", "title": "Open a Parquet dataset as a lazy dplyr tbl", "topics": [ "tbl_parquet" ] } ], "_readme": "https://github.com/pedrobtz/quak/raw/HEAD/README.md", "_rundeps": [ "cli", "curl", "DBI", "duckdb", "fs", "glue", "rlang" ], "_score": 2.6989700043360187, "_indexed": true, "_nocasepkg": "quak", "_universes": [ "pedrobtz" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-06-10T12:17:45.000Z", "distro": "noble", "commit": "6a39eb893aad9059537a4a69da47dbca80ba815a", "fileid": "92b443f563642c6a6410bef34ba75733b552d8ebb2aa423c49acbabedc39f88f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pedrobtz/actions/runs/27275320557" }, { "r": "4.6.0", "os": "linux", "version": "0.1.0", "date": "2026-06-10T12:17:49.000Z", "distro": "noble", "commit": "6a39eb893aad9059537a4a69da47dbca80ba815a", "fileid": "cf4aed475ff4e638b6b629202414893d01994a318305135c425d4016f15a40b9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pedrobtz/actions/runs/27275320557" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-06-10T12:16:46.000Z", "commit": "6a39eb893aad9059537a4a69da47dbca80ba815a", "fileid": "2cbc80585f42dbda803d2b31eba3360715561cbccf086f22229295ecf1a759f0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pedrobtz/actions/runs/27275320557" }, { "r": "4.6.0", "os": "mac", "version": "0.1.0", "date": "2026-06-10T12:17:07.000Z", "commit": "6a39eb893aad9059537a4a69da47dbca80ba815a", "fileid": "f1652f065c6a027d7a9449e057945ee2c1233a3d072e1ea4af2888c8b8513e71", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pedrobtz/actions/runs/27275320557" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-06-10T12:17:22.000Z", "commit": "6a39eb893aad9059537a4a69da47dbca80ba815a", "fileid": "219ef9578b00284a467e872e7297a72fe747a1ef6583c43465076a907796895d", "status": "success", "buildurl": "https://github.com/r-universe/pedrobtz/actions/runs/27275320557" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-06-10T12:17:11.000Z", "commit": "6a39eb893aad9059537a4a69da47dbca80ba815a", "fileid": "4ac4dffedc1dbdaa292166e862f066e31286b88e97aef5d0629ae0ae2a1206d2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pedrobtz/actions/runs/27275320557" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-06-10T12:16:43.000Z", "commit": "6a39eb893aad9059537a4a69da47dbca80ba815a", "fileid": "7cdc6fc7814f0b8ba66779720a0e0b458cefeda46c591b1f96c9b1dc55bb299a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pedrobtz/actions/runs/27275320557" }, { "r": "4.6.0", "os": "win", "version": "0.1.0", "date": "2026-06-10T12:16:28.000Z", "commit": "6a39eb893aad9059537a4a69da47dbca80ba815a", "fileid": "07bc383b9fbe2554b4028614eea579a1e6d25f1fc8d87e90f170ddd28785988d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pedrobtz/actions/runs/27275320557" } ] }