sql for partitioning — partition_mhw_events_truncated_sql • mhwci

sql for partitioning

Usage

partition_mhw_events_truncated_sql(
  mhw_table_name,
  partition_size_years = 3,
  start_year = 2040,
  end_year = 2069
)

Arguments

mhw_table_name: name of main metrics table to use
partition_size_years: width of partions in years
start_year: year to start partitions default 2040
end_year: year to end partitions default 2069

Value

character sql to create new table of truncated mwh by partition