Package: CDMConnector 1.7.0

Adam Black

CDMConnector: Connect to an OMOP Common Data Model

Provides tools for working with observational health data in the Observational Medical Outcomes Partnership (OMOP) Common Data Model format with a pipe friendly syntax. Common data model database table references are stored in a single compound object along with metadata.

Authors:Adam Black [aut, cre], Artem Gorbachev [aut], Edward Burn [aut], Marti Catala Sabate [aut]

CDMConnector_1.7.0.tar.gz
CDMConnector_1.7.0.tar.gz(r-4.5-noble)CDMConnector_1.7.0.tar.gz(r-4.4-noble)
CDMConnector_1.7.0.tgz(r-4.4-emscripten)CDMConnector_1.7.0.tgz(r-4.3-emscripten)
CDMConnector.pdf |CDMConnector.html✨
CDMConnector/json (API)
NEWS

# Install 'CDMConnector' in R:
install.packages('CDMConnector', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/darwin-eu/cdmconnector/issues

Pkgdown site:https://darwin-eu.github.io

7.73 score 13 packages 358 scripts 1.6k downloads 107 exports 39 dependencies

Last updated 6 days agofrom:aae82fd807. Checks:OK: 2. Indexed: no.

TargetResultDate
Doc / VignettesOKDec 19 2024
R-4.5-linuxOKDec 19 2024

Exports:%>%append_permanentappendPermanentas_dateasDateassert_tablesassert_write_schemaassertTablesassertWriteSchemaattritionbenchmarkCDMConnectorbindcdm_disconnectcdm_flattencdm_from_concdm_from_environmentcdm_from_filescdm_from_tablescdm_namecdm_samplecdm_select_tblcdm_subsetcdm_subset_cohortcdmConcdmDisconnectcdmFlattencdmFromConcdmFromEnvironmentcdmFromFilescdmFromTablescdmNamecdmSamplecdmSelectcdmSelectTblcdmSubsetcdmSubsetCohortcdmVersioncdmWriteSchemacohort_attritioncohort_countcohort_erafycohort_setcohort_unioncohortAttritioncohortCodelistcohortCountcohortErafycohortSetcohortUnioncomputecompute_querycomputeQuerycopy_cdm_tocopyCdmTodateadddatediffdatepartdbmsdbSourcedownload_eunomia_datadownloadEunomiaDatadropSourceTabledropTableeunomia_direunomia_is_availableeunomiaDireunomiaIsAvailableexample_datasetsexampleDatasetsgenerate_cohort_setgenerate_concept_cohort_setgenerateCohortSetgenerateConceptCohortSetin_schemainSchemainsertTableintersect_cohortsintersectCohortslist_tableslistSourceTableslistTablesnew_generated_cohort_setnewCohortTablenewGeneratedCohortSetread_cohort_setreadCohortSetreadSourceTablerecord_cohort_attritionrecordCohortAttritionrequire_eunomiarequireEunomiasettingssnapshotstowsummarise_quantilesummariseQuantilesummarize_quantilesummarizeQuantiletbl_grouptblGroupunion_cohortsunionCohortsunique_table_nameuniqueTableNamevalidate_cdmvalidateCdmversion

Dependencies:backportsbitbit64blobcheckmateclicliprcpp11crayonDBIdbplyrdplyrfansigenericsgluehmsjsonlitelifecyclemagrittromopgenericspillarpkgconfigprettyunitsprogresspurrrR6readrrlangsnakecasestringistringrtibbletidyrtidyselecttzdbutf8vctrsvroomwithr

CDM reference backends

Rendered froma05_cdm_reference_backends.Rmdusingknitr::rmarkdownon Dec 19 2024.

Last update: 2024-02-06
Started: 2023-03-09

CDMConnector and dbplyr

Rendered froma03_dbplyr.Rmdusingknitr::rmarkdownon Dec 19 2024.

Last update: 2024-04-03
Started: 2023-03-09

DBI connection examples

Rendered froma04_DBI_connection_examples.Rmdusingknitr::rmarkdownon Dec 19 2024.

Last update: 2024-12-19
Started: 2023-03-09

Getting Started

Rendered froma01_getting-started.Rmdusingknitr::rmarkdownon Dec 19 2024.

Last update: 2024-11-13
Started: 2023-03-09

Using CDM attributes

Rendered froma06_using_cdm_attributes.Rmdusingknitr::rmarkdownon Dec 19 2024.

Last update: 2024-05-04
Started: 2023-08-17

Working with cohorts

Rendered froma02_cohorts.Rmdusingknitr::rmarkdownon Dec 19 2024.

Last update: 2024-11-13
Started: 2024-02-06

Readme and manuals

Help Manual

Help pageTopics
Run a dplyr query and add the result set to an existingappendPermanent append_permanent
as.Date dbplyr translation wrapperasDate as_date
Assert that cdm has a writable schemaassertWriteSchema assert_write_schema
Assert that tables exist in a cdm objectassertTables assert_tables
Run benchmark of tasks using CDMConnectorbenchmarkCDMConnector
Create a cdm object from local tablescdm_from_tables
Get the CDM namecdm_name
Get underlying database connectioncdmCon
Disconnect the connection of the cdm objectcdmDisconnect cdm_disconnect
Flatten a cdm into a single observation tablecdmFlatten cdm_flatten
Create a CDM reference object from a database connectioncdmFromCon cdm_from_con
Create a CDM object from a pre-defined set of environment variablescdmFromEnvironment cdm_from_environment
Create a CDM reference from a folder containing parquet, csv, or feather filescdmFromFiles cdm_from_files
Subset a cdm object to a random sample of individualscdmSample cdm_sample
Select a subset of tables in a cdm reference objectcdmSelectTbl cdm_select_tbl
Subset a cdm object to a set of personscdmSubset cdm_subset
Subset a cdm to the individuals in one or more cohortscdmSubsetCohort cdm_subset_cohort
Get cdm write schemacdmWriteSchema
Get cohort counts from a generated_cohort_set object.cohort_count
Get attrition table from a cohort_table objectcohortAttrition cohort_attrition
Collapse cohort records within a certain number of dayscohortErafy cohort_erafy
Get cohort settings from a cohort_table objectcohortSet cohort_set
Union all cohorts in a cohort set with cohorts in a second cohort setcohortUnion cohort_union
Execute dplyr query and save result in remote databasecomputeQuery compute_query
Copy a cdm object from one database to anothercopyCdmTo copy_cdm_to
Add days or years to a date in a dplyr querydateadd
Compute the difference between two daysdatediff
Extract the day, month or year of a date in a dplyr pipelinedatepart
Get the database management system (dbms) from a cdm_reference or DBI connectiondbms
Create a source for a cdm in a database.dbSource
Download Eunomia data filesdownloadEunomiaData download_eunomia_data
Create a copy of an example OMOP CDM dataseteunomiaDir eunomia_dir
Has the Eunomia dataset been cached?eunomiaIsAvailable eunomia_is_available
List the available example CDM datasetsexampleDatasets example_datasets
Generate a cohort set on a cdm objectgenerateCohortSet generate_cohort_set
Create a new generated cohort set from a list of concept setsgenerateConceptCohortSet generate_concept_cohort_set
Helper for working with compound schemasinSchema in_schema
Intersect all cohorts in a single cohort tableintersectCohorts intersect_cohorts
List tables in a schemalistTables list_tables
Constructor for cohort_table objectsnewGeneratedCohortSet new_generated_cohort_set
Read a set of cohort definitions into RreadCohortSet read_cohort_set
Add attrition reason to a cohort_table objectrecord_cohort_attrition
Require eunomia to be available. The function makes sure that you can later create a eunomia database with 'eunomiaDir()'.requireEunomia require_eunomia
Extract CDM metadatasnapshot
Collect a list of lazy queries and save the results as filesstow
Quantile calculation using dbplyrsummariseQuantile summarise_quantile summarizeQuantile summarize_quantile
CDM table selection helpertblGroup tbl_group
Union all cohorts in a single cohort tableunionCohorts union_cohorts
Create a unique table name for temp tablesunique_table_name
Validation report for a CDMvalidateCdm validate_cdm
Get the CDM versionversion