use_duckdb() and close_duckdb() for database connection managementremove_duckdb() for cleanup and file removaltbl_redcap() for creating table references with dplyr supportcollect_labeled() and collect_labeled_list() for data with REDCap labelscollect_list() for splitting data into instrument-specific tableslist_to_env() for loading instruments into the global environmentmetadata() and logs() for accessing stored metadata and transfer logsinspect() for examining table structure for project datasave_parquet() for efficient data exportredcap_log()) with configurable date rangeslogs() to transfer_log()log_table_name parameter to transfer_log_table_name in redcap_to_db()redcap_uri parameter to url in redcap_to_db()verbose to echo in redcap_to_db() and change from logical to string options: "all" (default), "progress", or "none"metadata_table_name parameter to redcap_to_db() for storing REDCap field definitionsredcap_log_table_name parameter to redcap_to_db() for customizing REDCap audit log table name and schemaredcap_log_begin_date and redcap_log_end_date parameters to redcap_to_db() for configurable REDCap log date rangesraw_or_label, raw_or_label_headers, export_checkbox_label) in redcap_to_db() as labeling is now handled by collection functionsredcap_to_duckdb() to redcap_to_db() and gain a conn argument to support any database connectionredcap_transfer_result)log_table_name is NULL, then disable loggingoptimize_types and use connection class to check if DuckDBreturn_duckdb to return TRUE (complete) or FALSE (incomplete)max_retries from 3 to 10 retriesFirst release of redquack on CRAN
record_id_name = record_id)redcap_to_duckdb() function