Write clean aggregated data to BigQuery (full replace)

Overwrites the clean data table with the latest processed output.

bq_write_clean_data(
  dt,
  con = NULL,
  frequency = "monthly",
  chunk_size = 500000L,
  append_mode = FALSE
)

Arguments

dt

data.table with clean aggregated data

con

A DBI BigQuery connection (or NULL to create one)

frequency

Either "weekly" or "monthly"

chunk_size

Upper limit on upload

append_mode

FALSE=overwrite, TRUE=append