{
  "_id": "6af3a1aef58eaab799208a79",
  "Package": "ckdata",
  "Title": "Query Amazon Athena",
  "Version": "0.1.0",
  "Authors@R": "c(\nperson(\"Adam\", \"Blake\", email = \"adam@ablake.dev\", role = c(\"aut\", \"cre\")),\nperson(\"CourseKata\", role = \"cph\")\n)",
  "Description": "A read-only DBI and dbplyr interface to Amazon Athena. A\nshared Rust core executes Athena queries through Parquet and\nreturns Arrow results, including schemas for empty results.\nResearchers can use lazy dplyr queries, SQL, temporary saved\nresults and reproducible snapshots.",
  "License": "MIT + file LICENSE",
  "URL": "https://github.com/coursekata/ckdata",
  "BugReports": "https://github.com/coursekata/ckdata/issues",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "8.0.0",
  "Config/rextendr/version": "0.5.0",
  "SystemRequirements": "Cargo (Rust's package manager), rustc >= 1.94.1,\nxz, AWS CLI v2 (optional, for interactive AWS SSO sign-in)",
  "Config/testthat/edition": "3",
  "Config/Needs/development": "devtools, lintr, rcmdcheck, rextendr,\nroxygen2",
  "Config/pak/sysreqs": "cmake make libicu-dev libuv1-dev libxml2-dev\nlibzstd-dev libssl-dev xz-utils libclang-dev",
  "Repository": "https://coursekata.r-universe.dev",
  "Date/Publication": "2026-11-10 22:09:46 UTC",
  "RemoteUrl": "https://github.com/coursekata/ckdata",
  "RemoteRef": "v0.1.0",
  "RemoteSha": "c5e7a0a9fb87f627dce57a27e48c06bd37a9e8f0",
  "RemoteSubdir": "r",
  "NeedsCompilation": "yes",
  "Packaged": {
    "Date": "2026-11-10 22:35:40 UTC",
    "User": "root"
  },
  "Author": "Adam Blake [aut, cre],\nCourseKata [cph]",
  "Maintainer": "Adam Blake <adam@ablake.dev>",
  "_user": "coursekata",
  "_type": "src",
  "_file": "ckdata_0.1.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/505fa362eb7b367e32adbbe740e7175098c3250a8b92887a554e39d7aeb0a671",
  "_filesize": 824228,
  "_sha256": "505fa362eb7b367e32adbbe740e7175098c3250a8b92887a554e39d7aeb0a671",
  "_expires": "2027-02-18T22:58:52.000Z",
  "_created": "2026-11-10T22:35:40.000Z",
  "_published": "2026-11-10T22:58:54.469Z",
  "_upstream": "https://github.com/coursekata/ckdata",
  "_status": "success",
  "_maintainer": {
    "name": "Adam Blake",
    "email": "adam@ablake.dev",
    "login": "adamblake",
    "description": "\n",
    "uuid": 6201730
  },
  "_jobs": [
    {
      "job": 130181378793,
      "time": 381,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13809673115"
    },
    {
      "job": 130181378880,
      "time": 506,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13809059368"
    },
    {
      "job": 130181378832,
      "time": 383,
      "config": "linux-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13808584708"
    },
    {
      "job": 130181378956,
      "time": 480,
      "config": "linux-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13810252536"
    },
    {
      "job": 130181378798,
      "time": 624,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13810193164"
    },
    {
      "job": 130181378815,
      "time": 882,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13810527854"
    },
    {
      "job": 130181378752,
      "time": 499,
      "config": "macos-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13809962501"
    },
    {
      "job": 130181378780,
      "time": 1016,
      "config": "macos-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13811176220"
    },
    {
      "job": 130176888679,
      "time": 513,
      "config": "source",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13808944186"
    },
    {
      "job": 130181378801,
      "time": 128,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "FAIL",
      "artifact": ""
    },
    {
      "job": 130181379072,
      "time": 1023,
      "config": "windows-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13811057003"
    },
    {
      "job": 130181379181,
      "time": 872,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13811485033"
    },
    {
      "job": 130181378850,
      "time": 772,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13811026345"
    },
    {
      "job": 130181378803,
      "time": 1018,
      "config": "windows-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13810668248"
    },
    {
      "job": 130181378779,
      "time": 854,
      "config": "windows-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13810073700"
    }
  ],
  "_buildurl": "https://github.com/r-universe/coursekata/actions/runs/42915493087",
  "_commit": {
    "id": "c5e7a0a9fb87f627dce57a27e48c06bd37a9e8f0",
    "author": "Adam Blake <adam@ablake.dev>",
    "committer": "GitHub <noreply@github.com>",
    "message": "test(r): stabilize cancellation fixtures (BB-6316)",
    "time": 1794348586
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.2",
      "role": "Depends"
    },
    {
      "package": "arrow",
      "role": "Imports"
    },
    {
      "package": "bit64",
      "role": "Imports"
    },
    {
      "package": "cachem",
      "role": "Imports"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "version": ">= 1.3.0",
      "role": "Imports"
    },
    {
      "package": "dbplyr",
      "version": ">= 2.6.0",
      "role": "Imports"
    },
    {
      "package": "digest",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "version": ">= 1.1.0",
      "role": "Imports"
    },
    {
      "package": "fs",
      "role": "Imports"
    },
    {
      "package": "jsonlite",
      "role": "Imports"
    },
    {
      "package": "lubridate",
      "role": "Imports"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "nanoarrow",
      "role": "Imports"
    },
    {
      "package": "processx",
      "role": "Imports"
    },
    {
      "package": "purrr",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "version": ">= 1.2.0",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "withr",
      "role": "Imports"
    },
    {
      "package": "DBItest",
      "version": ">= 1.8.3",
      "role": "Suggests"
    },
    {
      "package": "RSQLite",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.1.7",
      "role": "Suggests"
    }
  ],
  "_owner": "coursekata",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-44",
      "n": 2
    },
    {
      "week": "2026-45",
      "n": 6
    },
    {
      "week": "2026-46",
      "n": 4
    }
  ],
  "_tags": [
    {
      "name": "v0.1.0",
      "date": "2026-11-10"
    }
  ],
  "_stars": 0,
  "_contributors": [
    {
      "user": "adamblake",
      "count": 12,
      "uuid": 6201730
    }
  ],
  "_userbio": {
    "uuid": 124006250,
    "type": "organization",
    "name": "CourseKata",
    "followers": 10,
    "description": "An innovative interactive online textbook leveraging research and student data to guide continuous improvement of online learning resources."
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/ckdata"
  },
  "_devurl": "https://github.com/coursekata/ckdata",
  "_searchresults": 7,
  "_cargo": true,
  "_topics": [
    "rust",
    "cargo"
  ],
  "_abi": {
    "exports": [
      {
        "key": "ckdata::CkConnection",
        "hash": "333f08ff06b8d4ea"
      },
      {
        "key": "ckdata::CkDriver",
        "hash": "8e8e47b8e9aec3c5"
      },
      {
        "key": "ckdata::CkResult",
        "hash": "ad45eb56e163a91b"
      },
      {
        "key": "ckdata::CkResultArrow",
        "hash": "c8343964399aedc7"
      }
    ],
    "imports": [
      {
        "key": "DBI::DBIConnection",
        "hash": "e723731c3dbaacdb"
      },
      {
        "key": "DBI::DBIDriver",
        "hash": "cd2584b29cba3eab"
      },
      {
        "key": "DBI::DBIObject",
        "hash": "09f3b098e445d20c"
      },
      {
        "key": "DBI::DBIResult",
        "hash": "8c1c65010fa94832"
      },
      {
        "key": "DBI::DBIResultArrow",
        "hash": "051413a35a5b9cbb"
      },
      {
        "key": "DBI::generic:dbBegin",
        "hash": "f3f6ecc203f27246"
      },
      {
        "key": "DBI::generic:dbBind",
        "hash": "b091f6e22e4ad362"
      },
      {
        "key": "DBI::generic:dbBindArrow",
        "hash": "ccd7f90e15bfbea4"
      },
      {
        "key": "DBI::generic:dbClearResult",
        "hash": "739c44c31c975b53"
      },
      {
        "key": "DBI::generic:dbColumnInfo",
        "hash": "4ca85a4be1b419b6"
      },
      {
        "key": "DBI::generic:dbCommit",
        "hash": "d3fead1fcd1a396a"
      },
      {
        "key": "DBI::generic:dbConnect",
        "hash": "b28fec54a15b1754"
      },
      {
        "key": "DBI::generic:dbDataType",
        "hash": "6e56b0e86f78e27d"
      },
      {
        "key": "DBI::generic:dbDisconnect",
        "hash": "7c1b532d5c90334c"
      },
      {
        "key": "DBI::generic:dbExistsTable",
        "hash": "2d41885c07ff912e"
      },
      {
        "key": "DBI::generic:dbFetch",
        "hash": "05b6728268c40323"
      },
      {
        "key": "DBI::generic:dbFetchArrow",
        "hash": "3083ea6556eeb8f8"
      },
      {
        "key": "DBI::generic:dbFetchArrowChunk",
        "hash": "2a849ae3fdb41571"
      },
      {
        "key": "DBI::generic:dbGetInfo",
        "hash": "80063f68739bb353"
      },
      {
        "key": "DBI::generic:dbGetQuery",
        "hash": "c958278636f3d3d7"
      },
      {
        "key": "DBI::generic:dbGetQueryArrow",
        "hash": "30d495de7dcc7051"
      },
      {
        "key": "DBI::generic:dbGetRowCount",
        "hash": "dfb79bfebf9f571f"
      },
      {
        "key": "DBI::generic:dbGetRowsAffected",
        "hash": "4c4f84ce2b8dac7a"
      },
      {
        "key": "DBI::generic:dbGetStatement",
        "hash": "0c7fc7f1d157be1d"
      },
      {
        "key": "DBI::generic:dbHasCompleted",
        "hash": "d2d001804dc9b889"
      },
      {
        "key": "DBI::generic:dbIsReadOnly",
        "hash": "3f425a6e206ea6a0"
      },
      {
        "key": "DBI::generic:dbIsValid",
        "hash": "f9deb8148f92cdb2"
      },
      {
        "key": "DBI::generic:dbListFields",
        "hash": "d1d193bdbf5fe5be"
      },
      {
        "key": "DBI::generic:dbListObjects",
        "hash": "bcf1e08da9fad268"
      },
      {
        "key": "DBI::generic:dbListTables",
        "hash": "66eba71dbc580096"
      },
      {
        "key": "DBI::generic:dbQuoteIdentifier",
        "hash": "82ddc9d8108b66bd"
      },
      {
        "key": "DBI::generic:dbQuoteLiteral",
        "hash": "1be33ddd40eea852"
      },
      {
        "key": "DBI::generic:dbQuoteString",
        "hash": "2e7910fcf67a4794"
      },
      {
        "key": "DBI::generic:dbRollback",
        "hash": "383702986c2e35b1"
      },
      {
        "key": "DBI::generic:dbSendQuery",
        "hash": "849b42bbbc07746d"
      },
      {
        "key": "DBI::generic:dbSendQueryArrow",
        "hash": "95ee3c3aac8ff957"
      },
      {
        "key": "DBI::generic:dbSendStatement",
        "hash": "517353b50e87da2a"
      },
      {
        "key": "DBI::generic:dbUnloadDriver",
        "hash": "4d8c3dc970b3732e"
      }
    ]
  },
  "_rbuild": "4.6.2",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/ckdata.html",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_cranurl": false,
  "_exports": [
    "approx_median",
    "approx_quantile",
    "ckdata",
    "ckdata_schema",
    "collect_saved",
    "daily_at",
    "dbBegin",
    "dbBind",
    "dbBindArrow",
    "dbClearResult",
    "dbColumnInfo",
    "dbCommit",
    "dbConnect",
    "dbDataType",
    "dbDisconnect",
    "dbExistsTable",
    "dbFetch",
    "dbFetchArrow",
    "dbFetchArrowChunk",
    "dbGetInfo",
    "dbGetQuery",
    "dbGetQueryArrow",
    "dbGetRowCount",
    "dbGetRowsAffected",
    "dbGetStatement",
    "dbHasCompleted",
    "dbIsReadOnly",
    "dbIsValid",
    "dbListFields",
    "dbListObjects",
    "dbListTables",
    "dbQuoteIdentifier",
    "dbQuoteLiteral",
    "dbQuoteString",
    "dbRollback",
    "dbSendQuery",
    "dbSendQueryArrow",
    "dbSendStatement",
    "dbUnloadDriver",
    "freshness_check",
    "lake_disconnect",
    "lake_query",
    "lake_tbl",
    "show"
  ],
  "_help": [
    {
      "page": "approx_quantile",
      "title": "Explicit approximate summaries for remote queries",
      "topics": [
        "approx_median",
        "approx_quantile"
      ]
    },
    {
      "page": "ckdata",
      "title": "A read-only DBI driver for Amazon Athena",
      "topics": [
        "CkConnection-class",
        "ckdata",
        "CkDriver-class",
        "CkResult-class",
        "CkResultArrow-class",
        "dbBegin,CkConnection-method",
        "dbBind,CkResult-method",
        "dbBindArrow,CkResult-method",
        "dbClearResult,CkResult-method",
        "dbColumnInfo,CkResult-method",
        "dbCommit,CkConnection-method",
        "dbConnect,CkDriver-method",
        "dbDataType,CkConnection-method",
        "dbDataType,CkDriver-method",
        "dbDisconnect,CkConnection-method",
        "dbExistsTable,CkConnection,character-method",
        "dbExistsTable,CkConnection,Id-method",
        "dbFetch,CkResult-method",
        "dbFetchArrow,CkResultArrow-method",
        "dbFetchArrowChunk,CkResultArrow-method",
        "dbGetInfo,CkConnection-method",
        "dbGetInfo,CkDriver-method",
        "dbGetInfo,CkResultArrow-method",
        "dbGetQuery,CkConnection,character-method",
        "dbGetQueryArrow,CkConnection,character-method",
        "dbGetRowCount,CkResult-method",
        "dbGetRowsAffected,CkResult-method",
        "dbGetStatement,CkResult-method",
        "dbHasCompleted,CkResult-method",
        "dbIsReadOnly,CkConnection-method",
        "dbIsReadOnly,CkDriver-method",
        "dbIsReadOnly,CkResult-method",
        "dbIsValid,CkConnection-method",
        "dbIsValid,CkDriver-method",
        "dbIsValid,CkResult-method",
        "dbListFields,CkConnection,character-method",
        "dbListFields,CkConnection,Id-method",
        "dbListObjects,CkConnection-method",
        "dbListTables,CkConnection-method",
        "dbQuoteIdentifier,CkConnection,character-method",
        "dbQuoteIdentifier,CkConnection,SQL-method",
        "dbQuoteLiteral,CkConnection-method",
        "dbQuoteString,CkConnection,character-method",
        "dbQuoteString,CkConnection,SQL-method",
        "dbRollback,CkConnection-method",
        "dbSendQuery,CkConnection,character-method",
        "dbSendQueryArrow,CkConnection,character-method",
        "dbSendStatement,CkConnection,character-method",
        "dbUnloadDriver,CkDriver-method",
        "show,CkConnection-method"
      ]
    },
    {
      "page": "ckdata_options",
      "title": "Options that control ckdata",
      "topics": [
        "ckdata_options"
      ]
    },
    {
      "page": "ckdata_schema",
      "title": "The database lake_tbl() reads from by default",
      "topics": [
        "ckdata_schema"
      ]
    },
    {
      "page": "ckdata_settings",
      "title": "Connection settings",
      "topics": [
        "ckdata_settings"
      ]
    },
    {
      "page": "ckdata_types",
      "title": "Result types and ordering",
      "topics": [
        "ckdata_types"
      ]
    },
    {
      "page": "collect_saved",
      "title": "Collect a query with temporary reuse or an indefinite Parquet snapshot",
      "topics": [
        "collect_saved"
      ]
    },
    {
      "page": "daily_at",
      "title": "Reuse results until a daily refresh or a source revision changes",
      "topics": [
        "daily_at",
        "freshness_check"
      ]
    },
    {
      "page": "lake_disconnect",
      "title": "Close the managed lake session",
      "topics": [
        "lake_disconnect"
      ]
    },
    {
      "page": "lake_query",
      "title": "Execute SQL through the shared query core",
      "topics": [
        "lake_query"
      ]
    },
    {
      "page": "lake_tbl",
      "title": "A lazy table in Amazon Athena",
      "topics": [
        "lake_tbl"
      ]
    }
  ],
  "_readme": "https://github.com/coursekata/ckdata/raw/v0.1.0/README.md",
  "_rundeps": [
    "arrow",
    "assertthat",
    "bit",
    "bit64",
    "blob",
    "cachem",
    "cli",
    "cpp11",
    "DBI",
    "dbplyr",
    "digest",
    "dplyr",
    "fastmap",
    "fs",
    "generics",
    "glue",
    "jsonlite",
    "lifecycle",
    "lubridate",
    "magrittr",
    "nanoarrow",
    "pillar",
    "pkgconfig",
    "processx",
    "ps",
    "purrr",
    "R6",
    "rlang",
    "stringi",
    "stringr",
    "tibble",
    "tidyr",
    "tidyselect",
    "timechange",
    "utf8",
    "vctrs",
    "withr"
  ],
  "_score": 2.1760912590556813,
  "_indexed": true,
  "_nocasepkg": "ckdata",
  "_universes": [
    "coursekata",
    "adamblake"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-11-10T22:43:22.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "c5e7a0a9fb87f627dce57a27e48c06bd37a9e8f0",
      "fileid": "https://r2.ropensci.org/458f0950d869c431ee1f5f16429ed2a1ea33dc8063305e4c6b0bafde47b45e93",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/coursekata/actions/runs/42915493087"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-11-10T22:43:51.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "c5e7a0a9fb87f627dce57a27e48c06bd37a9e8f0",
      "fileid": "https://r2.ropensci.org/fa20ef1a6e65971e5053e8fa373c4b51140bc0c8b447612523ef332c57955609",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/coursekata/actions/runs/42915493087"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-11-10T22:43:24.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "c5e7a0a9fb87f627dce57a27e48c06bd37a9e8f0",
      "fileid": "https://r2.ropensci.org/0f1cab4343baad3414bdd57eef8e1163b60bd42d3d8a6cf3d9ec96e80ecafe6e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/coursekata/actions/runs/42915493087"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-11-10T22:43:32.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "c5e7a0a9fb87f627dce57a27e48c06bd37a9e8f0",
      "fileid": "https://r2.ropensci.org/a252a0976e32122c17c5685fe695184fa81c8eac329f8703f171da75787c7433",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/coursekata/actions/runs/42915493087"
    }
  ]
}