Returns per-user billing eligibility under Slack's Fair Billing policy for the current team.

View-Specific Information

SELECT

The provider uses the Slack API to process search criteria that refer to the UserId column. This column supports server-side processing for the = and IN operators. The provider processes other filters client-side within the provider.

The TeamBillableInfo view exposes a TeamId pseudocolumn for use with org-level tokens. When you connect with an org-level token, supply TeamId in the WHERE clause to target a specific workspace.

Note: TeamId is only relevant when you connect with an org-level token. When you connect with a workspace-level token, the Slack API accepts the TeamId but ignores it and returns data for the authenticated workspace. Filtering on an invalid or empty TeamId therefore does not raise an error and does not return an empty result set.

For example, the following queries are processed server side by the Slack APIs:

SELECT * FROM TeamBillableInfo
SELECT * FROM TeamBillableInfo WHERE UserId = 'U01KZFNNTPC'
SELECT * FROM TeamBillableInfo WHERE UserId IN ('U01KZFNNTPC','U04QTH44D9S')
SELECT * FROM TeamBillableInfo WHERE TeamId = 'T01LC4ASB2M'

Columns

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.