Skip to contents

create a temporary table in the database of partitions named 'partitions', used to create joins on metrics tables in-database rather than in R space using dplyr for speed and so can use SQL this function has the destructive side effect of overwriting existing partitions table. this will disappear when the connection is disconnected or garbage collected

Usage

create_partition_table(
  conn,
  partition_size_years = 3,
  start_year = 2040,
  end_year = 2069
)

Arguments

conn

dbi database connection, see mhw_connect()

partition_size_years

integer width of partitions in whole years, not more than 10 usually

start_year

integer year to start partitioning (low end of range), default 2040

end_year

integer year to end portioning

Value

data frame copy of the table as created of with partition_name, partition_start_date, partition_end_date