Snowflake Chargeback
Overview
A Cost Center is a logical grouping of resources that allows you to track and analyze costs for a specific project, department, or any other user-defined category. Cost Centers can be used to create Chargebacks for teams in your organization. They help:
- Minimize the workload on central teams responsible for monitoring queries and corresponding metrics at Cost Center level
- Allocate costs across different organizational units
- Promote efficient use of Snowflake resources
- Flexibly distribute costs for shared warehouses using query cost attribution, users, roles, and more
Prerequisites
- A valid user account with 'Admin' permissions.
- At least one Data Source configured within the system.
Cost Centers Management
Create Cost Center
-
Access Cost Center Management: Navigate to the "Cost Center" tab in the "Chargeback" section from the main dashboard.
-
Initiate Creation: Click on the "Create Cost Center" button to open the Cost Center creation form.
-
Enter Basic Information:
- Cost Center Name: Provide a unique and descriptive name for your Cost Center.
- Owner Name: Input the owner of the Cost Center.
- Account: Select the relevant account from the dropdown list.
-
Configure Resources:
-
Resource Grouping: Specify how resources are categorized within the Cost Center. Options include:
- Database
- Warehouse
- Role
- User
-
Resource Selection: Use "Equals", "Starts with", "Ends with", or "Contains" to select resources.
-
Logical Operators: Combine multiple resource groups using "OR/AND" conditions.
-
Drag and Drop: Cost Centers can have overlapping rules. The order of the resources determines the precedence while calculating the cost. To adjust the order, click and drag using the triple line buttons.
Example: (Roles OR Warehouses AND Users) is different from (Roles AND Users OR Warehouses). The formula is calculated from top to bottom in the order of the resources.
-
-
Review and Save: Review the details and click "Create" to save the Cost Center.
Edit Cost Center
- User will be able to edit the Cost Center name, Owner Name, and Resource Grouping.
Delete Cost Center
- User will be able to delete the Cost Center from the list view.
Data Refresh
- Data in Cost Reporting Page may take up to 24 hours to reflect in reports.
Cost Center List View
Overview
The 'List of Cost Centers' provides a comprehensive table displaying all configured Cost Centers. Each row includes essential information for monitoring and management.
Key Information Displayed
- Cost Center Name: Unique identifier.
- Account: Associated accounts.
- Resources: Summary of configured resources.
- Owner: Assigned owner.
- Status: Current state ("In Progress" or "Live"). The transition from "In Progress" to "Live" may take up to 24 hours.
Actions Available
- Search Bar: Quick search by Cost Center Name or Owner Name.
- Expand: View the table in expanded mode.
- Edit: Modify configuration and resources.
- Delete: Remove the Cost Center.
- Export: Download data in CSV format.
Cost Reporting
The Cost Reporting section provides comprehensive insights into the costs associated with various resources. This section includes features for visualizing, filtering, and exporting cost data, ensuring users can analyze the Cost Centers effectively.
Features
- Visualization Types: Stacked Bar Chart, Line Chart.
- Granularity: Daily, Weekly, Monthly views.
- Filters: Date range, Cost Center Name, Account Name.
- Export Options: CSV and HTML formats.
Cost Reporting Table
The table provides a detailed breakdown of costs across different dimensions.
Hierarchical View:
- Level 1: Cost Center
- Level 2: Resource Types (Compute, Storage, Cloud Services)
- Level 3: Resource Details (Warehouse, Database, Role, User)
Resource costs are calculated based on their contribution to the Cost Center.
Data Refresh
Data refreshes automatically every 24 hours.
Cost Center Filters in Workloads Section
Filters for Cost Centers are available across all pages within the Workloads section.
Upcoming Improvements
Currently, Chargeback is an 'Admin' only feature. In the future, we plan to provide Role based access to the feature. We are continually adding support for more Snowflake services to Cost Center. If you have a specific attribute or Snowflake resource you'd like to use with Cost Center, please reach out to the Chaos Genius team.