Team Owners (✨ NEW)

✨ NEW TABLE - December 2025

🛠️ Partner API Alignment Migration

✅ This table is new as of December 2025 and will not be impacted

1️⃣ Migrate to this table by April 2026

2️⃣ Between April 2026 and July 2026, remove FUTURE__ prefix

A mapping table that contains team owner information extracted from partner team data. Tracks the primary owner (user) for each team along with team deletion timestamps to maintain ownership history even for deleted teams. This model provides a simplified view focused specifically on team ownership relationships.

This table serves to help understand the different roles assembled in the FUTURE__users table

SQL: FUTURE__team_owners

Schema

Column Name	Data Type	Description
Primary ID
id	INTEGER	User ID of the team owner (can be duplicated)
Other ID
team_id	INTEGER	Identifies the team owned
Timestamps
team_deleted_at	TIMESTAMP_NTZ	Timestamp when the team was deleted. Null for active teams that have not been deleted.

Data inclusion criteria

This table includes same rows as FUTURE__teams table and includes the values from owner_user_id

Data flow

Upstream tables	Downstream tables
`FUTURE__teams`	`FUTURE__users`