keithbinkly

description	Wait for Copilot to review a PR, then report CI + review state + actionable inline comments. Optionally loops.

Babysit PR

Copilot review often needs a manual request (review_on_push: false) and typically fires in ~3-5 minutes. This command waits as needed, checks CI and Copilot review state, then reports actionable next steps.

Usage:

• /babysit-pr 164 — check PR #164 (waits ≥5 min from PR creation)

keithbinkly

Absolutely! Let's create a similar persistent history solution for the #active_base section. This will dramatically improve performance since edw.fct_daily_acct_actives is likely another large table.

1. Create the Analytics Table for Period Actives

-- Create the persistent table for period actives history
DROP TABLE IF EXISTS analytics.ceridian_period_actives_history;
CREATE TABLE analytics.ceridian_period_actives_history (
    calendar_date DATE,
    calendar_week DATE,

keithbinkly

drop table if exists #acct_details;
SELECT * INTO #acct_details
  FROM public.bps_account_details
 where product_uid  in(229);


drop table if exists #cbr_tiers;
select distinct a.AccountKey
              , a.sor_uid
              , a.AccountIdentifier