Load Data into DuckDB Database

Loads buoy data from a data frame into the DuckDB database. Handles duplicates by using ON CONFLICT DO NOTHING.

Usage

load_to_duckdb(data, con, update_metadata = TRUE)

Arguments

data

Data frame containing buoy data

con

DBI connection object

update_metadata

Logical, whether to update station metadata (default: TRUE)

Value

Number of rows inserted

Examples

if (FALSE) { # \dontrun{
# Download and load data
data <- download_buoy_data(start_date = "2024-01-01")
con <- connect_duckdb()
rows_added <- load_to_duckdb(data, con)
DBI::dbDisconnect(con)
} # }