🚨 Required Action
If any of your queries referenceaggregate_mta.partition, you must update them before March 26, 2026. After that date, the partition column will no longer be available.
If you do not use partition, no action is required.
What’s Changing
Rockerbox is updating theaggregate_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: March 17, 2026
- After this date,
aggregate_mta.partitionwill 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 |