text: -- Here we drop the previous materialized views and rename the tmp
  ALTER MATERIALIZED VIEW bms_summary_10min_tmp RENAME TO bms_summary_10min;
  ALTER MATERIALIZED VIEW bms_summary_daily_tmp RENAME TO bms_summary_daily;
  ALTER MATERIALIZED VIEW bms_summary_hourly_tmp RENAME TO bms_summary_hourly;