Monta Data Warehouse: Operator-owned price groups now available

Action required: TEAM_PRICE_GROUPS and TEAM_PRICE_GROUP_PRICINGS are being deprecated

The TEAM_PRICE_GROUPS and TEAM_PRICE_GROUP_PRICINGS models are being replaced by the new PRICE_GROUPS and PRICE_GROUP_PRICINGS models. Please move your queries and integrations over before the dates below:

• Week 4, 2027 (week of 25. January): both old models get a `DEPRECATED__` prefix in their names. Any query that uses the current names will stop working. The data remains available, however, and repointing to the new name allows you to keep using the old models.

• Week 8, 2027 (week of 22. February): both old views are removed for good.

Until then, the old models keep working exactly as they do today and still return team-owned price groups only.

What's New

Price groups can now be owned by an operator as well as by a team, and the Monta Data Warehouse now includes both kinds:

• PRICE_GROUPS lists every price group for your teams and your operator, whether a team or the operator owns it.

• PRICE_GROUP_PRICINGS lists the pricing setup for each of those price groups.

Both views have two new columns, OWNER_TYPE (Team or Operator) and OWNER_ID, so you can see who owns each price group.

Why It Matters

Up to now, price groups set up at operator level in the Hub were missing from the Monta Data Warehouse. The new views include them, so your reports show all of your pricing.

How to Migrate

• Change TEAM_PRICE_GROUPS to PRICE_GROUPS, and TEAM_PRICE_GROUP_PRICINGS to PRICE_GROUP_PRICINGS.

• In PRICE_GROUP_PRICINGS, the price group reference is now called PRICE_GROUP_ID (it used to be TEAM_PRICE_GROUP_ID).

• TEAM_ID is empty for price groups an operator owns. To get the same results as the old views, filter on OWNER_TYPE = 'Team'.

You can find full column definitions in the Monta Data Warehouse documentation.