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