> ## Documentation Index
> Fetch the complete documentation index at: https://data-foundation.rockerbox.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.