Skip to contents

Connection helpers

aou_connect()
Create a connection to the database in All of Us
aou_sql()
Execute a SQL query on the All of Us database
aou_tables()
List tables in the AoU Database
aou_session_info()
Print session information for the AoU R environment

Workspace helpers

aou_ls_workspace()
List the current files in your workspace
aou_ls_bucket()
List the current files in your bucket
aou_workspace_to_bucket()
Save a file from your workspace to your bucket
aou_bucket_to_workspace()
Move files from a bucket to your workspace

Analysis helpers

aou_atlas_cohort()
Retrieve a cohort from ATLAS for use in All of Us
aou_concept_set()
Get occurrences of a concept set from AoU for a given cohort
aou_join()
Join current query to another table
aou_observation_period()
Generate an observation period table
aou_survey()
Function to query allofus observation table for survey responses
aou_compute()
Compute a dplyr tbl SQL query into a temp table
aou_collect()
Collect a tbl object and convert integer64 columns to double
aou_create_temp_table()
Creates a temporary table from a local data frame or tibble

Data dictionaries

aou_codebook
All of Us Modified Codebook
aou_table_info
Table of tables, columns, and use for researchers from the CT data dictionary
aou_health_history
All of Us Health History Codebook