Aggregate MTA: Partition Column Removal

🚨 Action Required by April 13th 2026

Update any queries that reference aggregate_mta.partition. After April 13th 2026, the partition column will be removed and those queries will fail.

If your queries do not reference partition, no action is required.

---

What’s Changing

Rockerbox is updating the aggregate_mta table to improve data sync performance during long backfills. As part of this update, the partition column is being removed.

---

Impact

If you do not use partition

No changes are required.

If you use partition

Your queries will fail once the change is applied unless updated beforehand.

---

Migration Timeline

• Automatic change applied: April 13, 2026.
• After this date, aggregate_mta.partition will not exist.

---

Required Updates

1. Remove partition from SELECT statements

2. Avoid SELECT *

If you currently rely on: SELECT * FROM aggregate_mta;

Update to an explicit column list to prevent unexpected breakage when schema changes occur.

3. Replace WHERE partition = ... Filters

Use Case	Before	After
Conversions filter	WHERE partition = 'mta'	WHERE even > 0
Spend filter	WHERE partition = 'included_spend'	WHERE included_spend > 0

Need Help?

If you’re unsure whether any production queries reference aggregate_mta.partition, please contact Rockerbox Support.