obt_customer_support_teams

Current list of help desk teams, for queue and assignment reporting.

Grain: one row per team (sm_team_key), with its current details, not a history. A team id on older tickets may not join, for example after the team was deleted in the help desk.
Joins: obt_customer_support_tickets.ticket_assignee_team_id on source_system, sm_store_id and team_id.

Columns

Column	Type	Description
`sm_team_key`	STRING	SourceMedium key for the team: the help desk’s team id namespaced by help desk and store.
`sm_store_id`	STRING	SourceMedium’s unique store identifier. For Shopify stores, derived from the myshopify.com domain; for other platforms (Amazon, TikTok Shop, Walmart.com), uses platform-specific identifiers.
`sm_channel`	STRING	Always online_dtc. Support data is not split by sales channel.
`source_system`	STRING	Help desk the team roster came from, as a lower-case source id.
`team_created_at`	TIMESTAMP	UTC timestamp when the team was created in the help desk.
`team_description`	STRING	Team description from the help desk, when one is set.
`team_id`	STRING	The help desk’s own id for the team. Join from obt_customer_support_tickets.ticket_assignee_team_id within the same source_system and sm_store_id.
`team_name`	STRING	Team name as shown in the help desk.