Using SELECT
Usage Groups
Feature Overview
Usage Groups provide a flexible way of creating cost categories within SELECT. They can be used to create showbacks or chargebacks for teams in your organization. That helps:
- Reduce the burden on central teams playing the role of 'query cop' 🚓
- Distribute costs across organizational units
- Encourage efficient use of Snowflake
- Flexibly allocate costs for shared warehouses
Managing Usage Groups
Usage Groups are managed from the Usage Groups page, accessible from the sidebar.
Creating Usage Groups
Usage Groups consist of a name and set of rules. To create a new Usage Group, click the 'New Group' button. An empty Usage Group will be created:
Start typing in the input to get suggestions on corresponding values, along with their cost. Rules can be added and deleted using the buttons on the right.
Usage Group Order
Usage Groups can have overlapping rules. The order of the Usage Groups determines the precedence when assigning workloads. To adjust the order, click and drag using the triple line buttons.
Usage Groups throughout SELECT
Usage Groups can currently be utilized on both the Usage Group and all workloads pages. The all workloads page provides the ability to filter to specific Usage Groups, in addition to slicing.
Upcoming improvements
In the future, Usage Groups will support more attributes including query metadata from dbt and BI tools, user roles, schemas, databases, etc. It will also be possible to filter for a specific Usage Group from most pages in the SELECT UI. If you have a specific attribute you'd like to use with Usage Groups, please reach out to the SELECT team.