select tmp.is_mr_add_partition3('tmp.is_mr_partition_SUBS_ACTIVATION', 20210101, 20210102, 'd', 5) CREATE OR REPLACE FUNCTION tmp.is_mr_add_partition3(prm_tbl text, prm_start integer, prm_end integer, ...
1. Verifies the correct number of partitions exist in the tail as defined by @days_to_keep_data 2. Verifies the partitons have no gaps in the tail (partitions older than the current partition), each ...