Skip to contents

Database Interactions

collect_query()
Collect Query from SQL File
oracle_con()
Oracle Database Connection
duck_con()
DuckDB Connection
write_duckdb()
Write a Table to a DuckDB Instance
temp_duck_table()
Create a Temporary DuckDB Table

Table Investigation

count_duplicates()
Count Duplicate Rows
`%notin%`
Not In
select_columns_na()
Select Columns That Have Missing Values

Calculation Shortcuts

geographic_distance()
Geographic Distance Between Two Pairs of Coordinates