{
  "_id": "6a106084acfb0bcc41ca7367",
  "Package": "CDMConnector",
  "Title": "Connect to an OMOP Common Data Model",
  "Version": "2.5.0",
  "Authors@R": "c(\nperson(\"Adam\", \"Black\", , \"ablack3@gmail.com\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0001-5576-8701\")),\nperson(\"Artem\", \"Gorbachev\", , \"artem.gorbachev@odysseusinc.com\", role = \"aut\"),\nperson(\"Edward\", \"Burn\", , \"edward.burn@ndorms.ox.ac.uk\", role = \"aut\"),\nperson(\"Marti\", \"Catala Sabate\", , \"marti.catalasabate@ndorms.ox.ac.uk\", role = \"aut\"),\nperson(\"Ioanna\", \"Nika\", , \"i.nika@darwin-eu.org\", role = \"aut\")\n)",
  "Description": "Provides tools for working with observational health data\nin the Observational Medical Outcomes Partnership (OMOP) Common\nData Model format with a pipe friendly syntax. Common data\nmodel database table references are stored in a single compound\nobject along with metadata.",
  "License": "Apache License (>= 2)",
  "URL": "https://darwin-eu.github.io/CDMConnector/,\nhttps://github.com/darwin-eu/CDMConnector",
  "BugReports": "https://github.com/darwin-eu/CDMConnector/issues",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.3",
  "Config/testthat/edition": "3",
  "Config/testthat/parallel": "false",
  "VignetteBuilder": "knitr",
  "Config/pak/sysreqs": "libicu-dev libssl-dev libx11-dev",
  "Repository": "https://darwin-eu.r-universe.dev",
  "Date/Publication": "2026-03-09 15:29:15 UTC",
  "RemoteUrl": "https://github.com/darwin-eu/cdmconnector",
  "RemoteRef": "HEAD",
  "RemoteSha": "1569ef993ec1c2119abc5cd5783b5525ee7e0a46",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-08 08:26:43 UTC",
    "User": "root"
  },
  "Author": "Adam Black [aut, cre] (ORCID: <https://orcid.org/0000-0001-5576-8701>),\nArtem Gorbachev [aut],\nEdward Burn [aut],\nMarti Catala Sabate [aut],\nIoanna Nika [aut]",
  "Maintainer": "Adam Black <ablack3@gmail.com>",
  "MD5sum": "ea7b9806c959e39868b4f2a8b722165e",
  "_user": "darwin-eu",
  "_type": "src",
  "_file": "CDMConnector_2.5.0.tar.gz",
  "_fileid": "cab1f312b5b7dcd8be64abd69c90358030d77258bcaaa054653e36aa17b17a17",
  "_filesize": 7000833,
  "_sha256": "cab1f312b5b7dcd8be64abd69c90358030d77258bcaaa054653e36aa17b17a17",
  "_created": "2026-05-08T08:26:43.000Z",
  "_published": "2026-05-22T13:56:20.024Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77394095240,
      "time": 333,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "6875092811"
    },
    {
      "job": 77394095219,
      "time": 336,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6875095468"
    },
    {
      "job": 77394095572,
      "time": 228,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6875062567"
    },
    {
      "job": 77394095468,
      "time": 301,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6875082767"
    },
    {
      "job": 77394094982,
      "time": 251,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6874998853"
    },
    {
      "job": 77394094556,
      "time": 131,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7162254721"
    },
    {
      "job": 77394095528,
      "time": 321,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "6875088862"
    },
    {
      "job": 77394095402,
      "time": 345,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6875095827"
    },
    {
      "job": 77394095482,
      "time": 370,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6875103307"
    }
  ],
  "_buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/25545260556",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/darwin-eu/cdmconnector",
  "_commit": {
    "id": "1569ef993ec1c2119abc5cd5783b5525ee7e0a46",
    "author": "ablack3 <ablack3@users.noreply.github.com>",
    "committer": "ablack3 <ablack3@users.noreply.github.com>",
    "message": "update site\n",
    "time": 1773070155
  },
  "_maintainer": {
    "name": "Adam Black",
    "email": "ablack3@gmail.com",
    "login": "ablack3",
    "uuid": 10227522,
    "orcid": "0000-0001-5576-8701"
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "httr",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "dbplyr",
      "version": ">= 2.5.0",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "version": ">= 0.3.0",
      "role": "Imports"
    },
    {
      "package": "checkmate",
      "role": "Imports"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "purrr",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "tidyselect",
      "role": "Imports"
    },
    {
      "package": "glue",
      "role": "Imports"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "withr",
      "role": "Imports"
    },
    {
      "package": "lifecycle",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "stringi",
      "role": "Imports"
    },
    {
      "package": "generics",
      "role": "Imports"
    },
    {
      "package": "tidyr",
      "role": "Imports"
    },
    {
      "package": "jsonlite",
      "role": "Imports"
    },
    {
      "package": "readr",
      "role": "Imports"
    },
    {
      "package": "omopgenerics",
      "version": ">= 1.2.0",
      "role": "Imports"
    },
    {
      "package": "SqlRender",
      "role": "Suggests"
    },
    {
      "package": "CirceR",
      "role": "Suggests"
    },
    {
      "package": "rJava",
      "role": "Suggests"
    },
    {
      "package": "covr",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "duckdb",
      "role": "Suggests"
    },
    {
      "package": "RSQLite",
      "role": "Suggests"
    },
    {
      "package": "RPostgres",
      "role": "Suggests"
    },
    {
      "package": "DatabaseConnector",
      "role": "Suggests"
    },
    {
      "package": "odbc",
      "role": "Suggests"
    },
    {
      "package": "ggplot2",
      "role": "Suggests"
    },
    {
      "package": "bigrquery",
      "role": "Suggests"
    },
    {
      "package": "lubridate",
      "role": "Suggests"
    },
    {
      "package": "clock",
      "role": "Suggests"
    },
    {
      "package": "tibble",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "pool",
      "role": "Suggests"
    },
    {
      "package": "snakecase",
      "role": "Suggests"
    },
    {
      "package": "digest",
      "role": "Suggests"
    },
    {
      "package": "rstudioapi",
      "role": "Suggests"
    },
    {
      "package": "uuid",
      "role": "Suggests"
    },
    {
      "package": "arrow",
      "role": "Enhances"
    }
  ],
  "_owner": "darwin-eu",
  "_selfowned": true,
  "_usedby": 10,
  "_updates": [
    {
      "week": "2025-20",
      "n": 1
    },
    {
      "week": "2025-22",
      "n": 2
    },
    {
      "week": "2025-26",
      "n": 19
    },
    {
      "week": "2025-27",
      "n": 1
    },
    {
      "week": "2025-28",
      "n": 4
    },
    {
      "week": "2025-30",
      "n": 2
    },
    {
      "week": "2025-31",
      "n": 8
    },
    {
      "week": "2025-32",
      "n": 8
    },
    {
      "week": "2025-33",
      "n": 1
    },
    {
      "week": "2025-36",
      "n": 2
    },
    {
      "week": "2025-38",
      "n": 1
    },
    {
      "week": "2025-43",
      "n": 1
    },
    {
      "week": "2025-44",
      "n": 1
    },
    {
      "week": "2026-01",
      "n": 10
    },
    {
      "week": "2026-02",
      "n": 13
    },
    {
      "week": "2026-06",
      "n": 2
    },
    {
      "week": "2026-07",
      "n": 44
    },
    {
      "week": "2026-08",
      "n": 2
    },
    {
      "week": "2026-09",
      "n": 1
    },
    {
      "week": "2026-10",
      "n": 4
    },
    {
      "week": "2026-11",
      "n": 2
    }
  ],
  "_tags": [
    {
      "name": "v2.1.0",
      "date": "2025-06-25"
    },
    {
      "name": "v2.2.0",
      "date": "2025-09-16"
    },
    {
      "name": "v2.3.0",
      "date": "2026-01-07"
    },
    {
      "name": "v2.4.0",
      "date": "2026-02-16"
    },
    {
      "name": "v2.5.0",
      "date": "2026-03-09"
    }
  ],
  "_stars": 15,
  "_contributors": [
    {
      "user": "ablack3",
      "count": 842,
      "uuid": 10227522
    },
    {
      "user": "catalamarti",
      "count": 83,
      "uuid": 18575244
    },
    {
      "user": "edward-burn",
      "count": 67,
      "uuid": 9583964
    },
    {
      "user": "ioannanika",
      "count": 23,
      "uuid": 45609421
    },
    {
      "user": "prijnbeek",
      "count": 13,
      "uuid": 7252105
    },
    {
      "user": "nmercadeb",
      "count": 9,
      "uuid": 61558739
    },
    {
      "user": "ginberg",
      "count": 6,
      "uuid": 7089667
    },
    {
      "user": "tsemharb",
      "count": 4,
      "uuid": 28675893
    },
    {
      "user": "james-cockayne",
      "count": 3,
      "uuid": 150046545
    },
    {
      "user": "mvankessel-emc",
      "count": 3,
      "uuid": 112690347
    },
    {
      "user": "hadley",
      "count": 1,
      "uuid": 4196
    },
    {
      "user": "mimiyuchenguo",
      "count": 1,
      "uuid": 57181081
    }
  ],
  "_userbio": {
    "uuid": 120334168,
    "type": "organization",
    "name": "Darwin EU® Public Code Repository",
    "description": "DARWIN EU® will deliver real-world evidence from across Europe on diseases, populations and the uses and performance of medicines."
  },
  "_downloads": {
    "count": 2202,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/CDMConnector"
  },
  "_devurl": "https://github.com/darwin-eu/cdmconnector",
  "_pkgdown": "https://darwin-eu.github.io/CDMConnector/",
  "_searchresults": 600,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/CDMConnector.html",
    "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",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/darwin-eu/cdmconnector",
  "_realowner": "darwin-eu",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2022-09-29"
    },
    {
      "version": "0.3.0",
      "date": "2022-11-29"
    },
    {
      "version": "0.3.1",
      "date": "2022-12-01"
    },
    {
      "version": "0.4.0",
      "date": "2023-01-22"
    },
    {
      "version": "0.4.1",
      "date": "2023-01-24"
    },
    {
      "version": "0.5.0",
      "date": "2023-03-09"
    },
    {
      "version": "0.5.1",
      "date": "2023-03-23"
    },
    {
      "version": "0.6.0",
      "date": "2023-05-05"
    },
    {
      "version": "1.0.0",
      "date": "2023-06-12"
    },
    {
      "version": "1.1.0",
      "date": "2023-08-17"
    },
    {
      "version": "1.1.1",
      "date": "2023-08-22"
    },
    {
      "version": "1.1.2",
      "date": "2023-08-24"
    },
    {
      "version": "1.1.3",
      "date": "2023-10-14"
    },
    {
      "version": "1.1.4",
      "date": "2023-10-21"
    },
    {
      "version": "1.2.0",
      "date": "2023-10-31"
    },
    {
      "version": "1.2.1",
      "date": "2024-01-18"
    },
    {
      "version": "1.3.0",
      "date": "2024-02-05"
    },
    {
      "version": "1.3.1",
      "date": "2024-04-02"
    },
    {
      "version": "1.3.2",
      "date": "2024-05-01"
    },
    {
      "version": "1.4.0",
      "date": "2024-05-03"
    },
    {
      "version": "1.5.0",
      "date": "2024-07-16"
    },
    {
      "version": "1.6.0",
      "date": "2024-11-14"
    },
    {
      "version": "1.6.1",
      "date": "2024-11-29"
    },
    {
      "version": "1.7.0",
      "date": "2024-12-19"
    },
    {
      "version": "2.0.0",
      "date": "2025-02-22"
    },
    {
      "version": "2.1.0",
      "date": "2025-06-25"
    },
    {
      "version": "2.1.1",
      "date": "2025-07-10"
    },
    {
      "version": "2.2.0",
      "date": "2025-09-16"
    },
    {
      "version": "2.3.0",
      "date": "2026-01-10"
    },
    {
      "version": "2.4.0",
      "date": "2026-02-16"
    },
    {
      "version": "2.5.0",
      "date": "2026-03-08"
    },
    {
      "version": "2.5.1",
      "date": "2026-04-03"
    }
  ],
  "_exports": [
    "%>%",
    "appendPermanent",
    "asDate",
    "attrition",
    "benchmarkCDMConnector",
    "bind",
    "cdmCommentContents",
    "cdmCon",
    "cdmDisconnect",
    "cdmFlatten",
    "cdmFromCohortSet",
    "cdmFromCon",
    "cdmFromTables",
    "cdmName",
    "cdmReference",
    "cdmSample",
    "cdmSelect",
    "cdmSubset",
    "cdmSubsetCohort",
    "cdmVersion",
    "cdmWriteSchema",
    "cohdSimilarConcepts",
    "cohortCodelist",
    "cohortCount",
    "compute",
    "computeDataHashByTable",
    "computeQuery",
    "copyCdmTo",
    "dateadd",
    "datediff",
    "datepart",
    "dbms",
    "dbSource",
    "downloadEunomiaData",
    "dropSourceTable",
    "dropTable",
    "eunomiaDir",
    "eunomiaIsAvailable",
    "exampleDatasets",
    "generateCohortSet",
    "generateCohortSet2",
    "generateConceptCohortSet",
    "inSchema",
    "insertCdmTo",
    "insertTable",
    "listSourceTables",
    "listTables",
    "newCohortTable",
    "readCohortSet",
    "readSourceTable",
    "recordCohortAttrition",
    "requireEunomia",
    "settings",
    "snapshot",
    "sourceType",
    "summariseQuantile",
    "summariseQuantile2",
    "tblGroup",
    "uniqueTableName",
    "version"
  ],
  "_help": [
    {
      "page": "appendPermanent",
      "title": "Run a dplyr query and add the result set to an existing",
      "topics": [
        "appendPermanent"
      ]
    },
    {
      "page": "asDate",
      "title": "as.Date dbplyr translation wrapper",
      "topics": [
        "asDate"
      ]
    },
    {
      "page": "benchmarkCDMConnector",
      "title": "Run benchmark of tasks using CDMConnector",
      "topics": [
        "benchmarkCDMConnector"
      ]
    },
    {
      "page": "cdmCommentContents",
      "title": "Insert Patient CDM Contents as Aligned Comments in RStudio",
      "topics": [
        "cdmCommentContents"
      ]
    },
    {
      "page": "cdmCon",
      "title": "Get underlying database connection",
      "topics": [
        "cdmCon"
      ]
    },
    {
      "page": "cdmDisconnect.db_cdm",
      "title": "Disconnect the connection of the cdm object",
      "topics": [
        "cdmDisconnect.db_cdm"
      ]
    },
    {
      "page": "cdmFlatten",
      "title": "Flatten a cdm into a single observation table",
      "topics": [
        "cdmFlatten"
      ]
    },
    {
      "page": "cdmFromCohortSet",
      "title": "Build a Synthetic CDM from a Cohort Set",
      "topics": [
        "cdmFromCohortSet"
      ]
    },
    {
      "page": "cdmFromCon",
      "title": "Create a CDM reference object from a database connection",
      "topics": [
        "cdmFromCon"
      ]
    },
    {
      "page": "cdmSample",
      "title": "Subset a cdm object to a random sample of individuals",
      "topics": [
        "cdmSample"
      ]
    },
    {
      "page": "cdmSubset",
      "title": "Subset a cdm object to a set of persons",
      "topics": [
        "cdmSubset"
      ]
    },
    {
      "page": "cdmSubsetCohort",
      "title": "Subset a cdm to the individuals in one or more cohorts",
      "topics": [
        "cdmSubsetCohort"
      ]
    },
    {
      "page": "cdmWriteSchema",
      "title": "Get cdm write schema",
      "topics": [
        "cdmWriteSchema"
      ]
    },
    {
      "page": "cohdSimilarConcepts",
      "title": "Get similar concepts from Columbia Open Health Data (COHD) API",
      "topics": [
        "cohdSimilarConcepts"
      ]
    },
    {
      "page": "computeDataHashByTable",
      "title": "Compute a hash for each CDM table",
      "topics": [
        "computeDataHashByTable"
      ]
    },
    {
      "page": "computeQuery",
      "title": "Execute dplyr query and save result in remote database",
      "topics": [
        "computeQuery"
      ]
    },
    {
      "page": "copyCdmTo",
      "title": "Copy a cdm object from one database to another",
      "topics": [
        "copyCdmTo"
      ]
    },
    {
      "page": "dateadd",
      "title": "Add days or years to a date in a dplyr query",
      "topics": [
        "dateadd"
      ]
    },
    {
      "page": "datediff",
      "title": "Compute the difference between two days",
      "topics": [
        "datediff"
      ]
    },
    {
      "page": "datepart",
      "title": "Extract the day, month or year of a date in a dplyr pipeline",
      "topics": [
        "datepart"
      ]
    },
    {
      "page": "dbms",
      "title": "Get the database management system (dbms) from a cdm_reference or DBI connection",
      "topics": [
        "dbms"
      ]
    },
    {
      "page": "dbSource",
      "title": "Create a source for a cdm in a database.",
      "topics": [
        "dbSource"
      ]
    },
    {
      "page": "downloadEunomiaData",
      "title": "Download Eunomia data files",
      "topics": [
        "downloadEunomiaData"
      ]
    },
    {
      "page": "dropTable.db_cdm",
      "title": "Drop table from a database backed cdm object",
      "topics": [
        "dropTable.db_cdm"
      ]
    },
    {
      "page": "eunomiaDir",
      "title": "Create a copy of an example OMOP CDM dataset",
      "topics": [
        "eunomiaDir"
      ]
    },
    {
      "page": "eunomiaIsAvailable",
      "title": "Has the Eunomia dataset been cached?",
      "topics": [
        "eunomiaIsAvailable"
      ]
    },
    {
      "page": "exampleDatasets",
      "title": "List the available example CDM datasets",
      "topics": [
        "exampleDatasets"
      ]
    },
    {
      "page": "generateCohortSet",
      "title": "Generate a cohort set on a cdm object",
      "topics": [
        "generateCohortSet"
      ]
    },
    {
      "page": "generateCohortSet2",
      "title": "Generate a cohort set on a CDM object (optimized, no Java dependency)",
      "topics": [
        "generateCohortSet2"
      ]
    },
    {
      "page": "generateConceptCohortSet",
      "title": "Create a new generated cohort set from a list of concept sets",
      "topics": [
        "generateConceptCohortSet"
      ]
    },
    {
      "page": "inSchema",
      "title": "Helper for working with compound schema",
      "topics": [
        "inSchema"
      ]
    },
    {
      "page": "listTables",
      "title": "List tables in a schema",
      "topics": [
        "listTables"
      ]
    },
    {
      "page": "readCohortSet",
      "title": "Read a set of cohort definitions into R",
      "topics": [
        "readCohortSet"
      ]
    },
    {
      "page": "requireEunomia",
      "title": "Require eunomia to be available. The function makes sure that you can later create a eunomia database with 'eunomiaDir()'.",
      "topics": [
        "requireEunomia"
      ]
    },
    {
      "page": "snapshot",
      "title": "Extract CDM metadata",
      "topics": [
        "snapshot"
      ]
    },
    {
      "page": "summariseQuantile",
      "title": "Quantile calculation using dbplyr",
      "topics": [
        "summariseQuantile"
      ]
    },
    {
      "page": "summariseQuantile2",
      "title": "Quantile calculation using dbplyr",
      "topics": [
        "summariseQuantile2"
      ]
    },
    {
      "page": "tblGroup",
      "title": "CDM table selection helper",
      "topics": [
        "tblGroup"
      ]
    },
    {
      "page": "version",
      "title": "Get the CDM version",
      "topics": [
        "version"
      ]
    }
  ],
  "_pkglogo": "https://github.com/darwin-eu/cdmconnector/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/darwin-eu/cdmconnector/raw/HEAD/README.md",
  "_rundeps": [
    "askpass",
    "backports",
    "bit",
    "bit64",
    "blob",
    "checkmate",
    "cli",
    "clipr",
    "cpp11",
    "crayon",
    "curl",
    "DBI",
    "dbplyr",
    "dplyr",
    "generics",
    "glue",
    "hms",
    "httr",
    "jsonlite",
    "lifecycle",
    "magrittr",
    "mime",
    "omopgenerics",
    "openssl",
    "pillar",
    "pkgconfig",
    "prettyunits",
    "progress",
    "purrr",
    "R6",
    "readr",
    "rlang",
    "snakecase",
    "stringi",
    "stringr",
    "sys",
    "tibble",
    "tidyr",
    "tidyselect",
    "tzdb",
    "utf8",
    "vctrs",
    "vroom",
    "withr"
  ],
  "_vignettes": [
    {
      "source": "a03_dbplyr.Rmd",
      "filename": "a03_dbplyr.html",
      "title": "CDMConnector and dbplyr",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Set up",
        "Creating the cdm reference",
        "Putting it all together",
        "Behind the scenes"
      ],
      "created": "2023-03-06 16:28:00",
      "modified": "2025-02-10 15:46:23",
      "commits": 9
    },
    {
      "source": "a07_batch-optimization.Rmd",
      "filename": "a07_batch-optimization.html",
      "title": "DAG-Based Batch Optimization for Cohort SQL Generation",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Overview",
        "The One-at-a-Time Approach",
        "The Optimized Batch DAG",
        "Worked Example: Three Drug Exposure Cohorts",
        "One-at-a-Time DAG",
        "Optimized Batch DAG",
        "How Equivalence Is Guaranteed",
        "1. Same Builder, Different Assembly",
        "2. Domain Filtering Includes Source Concepts",
        "3. QualifiedLimit Preservation",
        "4. Automated Equivalence Validation",
        "Safety Mechanisms",
        "Performance Characteristics",
        "By Workload Type",
        "Independent Cohorts (Different Domains)",
        "Independent Cohorts (Overlapping Domains)",
        "Subset Cohorts (Same Primary Criteria, Different Inclusion Rules)",
        "Large Phenotype Libraries (100+ Cohorts)",
        "Summary Table",
        "Code Example",
        "Single Cohort (No Optimization)",
        "Batch (Optimized)",
        "With CDMConnector",
        "Validating Equivalence",
        "Debugging",
        "Appendix: How the DAG Is Enforced"
      ],
      "created": "2026-03-08 03:10:43",
      "modified": "2026-03-09 15:29:15",
      "commits": 2
    },
    {
      "source": "a04_DBI_connection_examples.Rmd",
      "filename": "a04_DBI_connection_examples.html",
      "title": "DBI connection examples",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Postgres",
        "Redshift",
        "SQL Server",
        "Snowflake",
        "Databricks/Spark",
        "Duckdb"
      ],
      "created": "2023-03-06 16:28:00",
      "modified": "2026-02-12 19:18:56",
      "commits": 10
    },
    {
      "source": "a01_getting-started.Rmd",
      "filename": "a01_getting-started.html",
      "title": "Getting Started",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Creating a reference to the OMOP CDM",
        "Joining tables",
        "Saving query results to the database",
        "Selecting a subset of CDM tables",
        "Subsetting a CDM",
        "Flatten a CDM",
        "Closing connections",
        "Summary"
      ],
      "created": "2023-03-06 16:28:00",
      "modified": "2025-07-10 12:16:25",
      "commits": 17
    },
    {
      "source": "a08_dag-caching.Rmd",
      "filename": "a08_dag-caching.html",
      "title": "Incremental DAG Caching for Cohort Generation",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Overview",
        "How It Works",
        "The Execution DAG",
        "Merkle-Tree Hashing",
        "The Cache Registry",
        "Stable Table Naming",
        "Cache-Aware Execution",
        "Usage",
        "Basic Usage",
        "SQL-Only Usage",
        "What Gets Cached vs. Not",
        "Cached (persistent across runs)",
        "Not Cached (rebuilt every run)",
        "Why Concept Sets Aren't Individually Cached",
        "Cache Management",
        "Inspecting the Cache",
        "Garbage Collection",
        "Clearing the Cache",
        "Correctness Guarantees",
        "When to Use Caching",
        "Example: Incremental Update"
      ],
      "created": "2026-03-08 03:10:43",
      "modified": "2026-03-08 03:10:43",
      "commits": 1
    },
    {
      "source": "a09_benchmarking.Rmd",
      "filename": "a09_benchmarking.html",
      "title": "Multi-Database Benchmarking: Old vs New Cohort Generation",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Overview",
        "Performance improvements with the new approach",
        "How to run the benchmark",
        "Prerequisites",
        "Single database",
        "Multiple databases",
        "Benchmark results CSV (timing)",
        "Equivalence CSV (same results)",
        "Summary"
      ],
      "created": "2026-03-08 03:10:43",
      "modified": "2026-03-08 03:10:43",
      "commits": 1
    },
    {
      "source": "a06_using_cdm_attributes.Rmd",
      "filename": "a06_using_cdm_attributes.html",
      "title": "Using CDM attributes",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Set up",
        "CDM reference attributes",
        "CDM name",
        "CDM version",
        "Database connection",
        "Cohort attributes",
        "Generated cohort set",
        "Creating a bespoke cohort"
      ],
      "created": "2023-08-01 13:26:24",
      "modified": "2025-02-10 15:46:23",
      "commits": 11
    },
    {
      "source": "a02_cohorts.Rmd",
      "filename": "a02_cohorts.html",
      "title": "Working with cohorts",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Cohort Generation",
        "Atlas cohort definitions",
        "Subset a cohort",
        "Custom Cohort Creation"
      ],
      "created": "2024-01-22 18:13:26",
      "modified": "2025-07-10 12:16:25",
      "commits": 13
    }
  ],
  "_score": 11.739853050014828,
  "_indexed": true,
  "_nocasepkg": "cdmconnector",
  "_universes": [
    "darwin-eu",
    "ablack3"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "2.5.0",
      "date": "2026-05-08T08:29:07.000Z",
      "distro": "noble",
      "commit": "1569ef993ec1c2119abc5cd5783b5525ee7e0a46",
      "fileid": "78b1077653cb376e8e356f7d93ecfc04fd7300c45bf29fda44705e8d52732495",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/25545260556"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "2.5.0",
      "date": "2026-05-08T08:29:26.000Z",
      "distro": "noble",
      "commit": "1569ef993ec1c2119abc5cd5783b5525ee7e0a46",
      "fileid": "661a8a1d8b42e8dfca4087612b03d5a84a43c07cd5caaf2b40d1a304c96a8148",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/25545260556"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "2.5.0",
      "date": "2026-05-08T08:28:47.000Z",
      "commit": "1569ef993ec1c2119abc5cd5783b5525ee7e0a46",
      "fileid": "a020498431edc1855ab925ab7bbe178d7fb266bd7389095e791b76a788eff336",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/25545260556"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "2.5.0",
      "date": "2026-05-08T08:28:44.000Z",
      "commit": "1569ef993ec1c2119abc5cd5783b5525ee7e0a46",
      "fileid": "aaba9b4f4cb7ffe360c268c77e056259f3aeff6cd9dba564128721469ebe47a2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/25545260556"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "2.5.0",
      "date": "2026-05-08T08:28:14.000Z",
      "commit": "1569ef993ec1c2119abc5cd5783b5525ee7e0a46",
      "fileid": "92a38ebff24594ae088a8c1e724c21352a55c47c85627a87ca0b123236d53492",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/25545260556"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "2.5.0",
      "date": "2026-05-08T08:28:10.000Z",
      "commit": "1569ef993ec1c2119abc5cd5783b5525ee7e0a46",
      "fileid": "e9ab25b7019c5d7a6a66fbc1f45721adc2d82141a149c0878869a45dba3da49b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/25545260556"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "2.5.0",
      "date": "2026-05-08T08:28:25.000Z",
      "commit": "1569ef993ec1c2119abc5cd5783b5525ee7e0a46",
      "fileid": "eedcb602d3c09af0196164880c3781725f6a1fc5070cc401b2ad943b09340ed7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/25545260556"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "2.5.0",
      "date": "2026-05-22T13:56:00.000Z",
      "commit": "1569ef993ec1c2119abc5cd5783b5525ee7e0a46",
      "fileid": "1ec80f3e41cddaaa3617420cc7f851a0c8dfb400fb392f1fc729618a3af1d568",
      "status": "success",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/25545260556"
    }
  ]
}