List tables in the AoU Database

Description

Prints a list of all of the tables in the All of Us Big Query Database.

Usage

aou_tables(remove_na = TRUE, ..., con = getOption("aou.default.con"))

Arguments

remove_na	Whether to remove tables that are not in the data dictionary. Defaults to TRUE
…	Not currently used
con	Connection to the allofus SQL database. Defaults to getOption(“aou.default.con”), which is created automatically with aou_connect().

Value

A dataframe with the table names and the number of columns

Examples

library("allofus")


con <- aou_connect()
aou_tables()

# A tibble: 66 × 2
   table_name               columns                                             
   <chr>                    <chr>                                               
 1 concept_ancestor         ancestor_concept_id, descendant_concept_id, min_lev…
 2 cb_criteria_ancestor     ancestor_id, descendant_id                          
 3 attribute_definition     attribute_definition_id, attribute_name, attribute_…
 4 cdm_source               cdm_source_name, cdm_source_abbreviation, cdm_holde…
 5 concept_class            concept_class_id, concept_class_name, concept_class…
 6 concept                  concept_id, concept_name, domain_id, vocabulary_id,…
 7 concept_synonym          concept_id, concept_synonym_name, language_concept_…
 8 cb_criteria_relationship concept_id_1, concept_id_2                          
 9 concept_relationship     concept_id_1, concept_id_2, relationship_id, valid_…
10 condition_occurrence     condition_occurrence_id, person_id, condition_conce…
# ℹ 56 more rows