Skip to contents

All functions

connections
Database Connection Management Functions for establishing and managing Oracle database connections using keyring-based credential storage.
create_connection()
Create an Oracle database connection
create_dsn_connection()
Create a connection using a pre-configured ODBC DSN
download_observer_tables()
Download observer tables from LOTUS database
download_tables()
Download multiple tables in parallel
downloads
Parallel Data Download
get_available_years()
Get available years for a table
optimal_cores()
Determine optimal number of cores for parallel processing
parallel_download()
Download a table in parallel by year
parallel_dsn_download()
Download a DSN table in parallel by year
peek
Table Preview Functions Functions for quickly inspecting database tables without full download.
peek_columns()
Peek at table shape and metadata
peek_sample()
Quick sample from a table
peek_table()
Peek at a database table
safe_disconnect()
Safely disconnect from a database
setup_credentials()
Set up database credentials in the system keyring
simple_download()
Download a table using a single connection