Skip to contents

Setup and sources

thip_setup()
Configure database credentials once in your THIP account
thip_connect()
Connect to THIP using the standard ClickHouse DBI backend
thip_tables()
List THIP table metadata
thip_columns()
Inspect column metadata without reading table records
thip_table()
Create a lazy dbplyr table
thip_date_audit()
Audit raw and converted date columns

Filter, retrieve and flag

thip_filter_icd()
Filter a lazy THIP table by ICD codes
thip_window()
Plan retrieval of records in person-specific date windows
collect(<thip_window_plan>)
Execute a THIP window plan
icd_flag()
Flag custom ICD conditions in local data

Compatibility and convenience

thip_disconnect()
Release a THIP connection
thip_collect()
Collect a bounded lazy query without silently truncating it