ckdata

Query the CourseKata data lake from R.

Installation

pak::pak("coursekata/ckdata-r")

Usage

library(ckdata)
library(dplyr)

lake_tbl("mart_classes") |>
  count() |>
  collect()

lake_tbl() returns a lazy dbplyr table reference into the lake, with the Athena connection opened and managed for you. collect_cached() is a drop-in for dplyr::collect() that caches big pulls to a local parquet file.

Getting connected

A first-time AWS sign-in plus a one-line ~/.Renviron setup are required before any query. That setup — and the query walkthrough — live in the internal Datalake docs on Confluence, kept out of this repo so it stays shareable. Start there.

Reference

Function reference: https://coursekata.github.io/ckdata-r.