Usage Metering Upload
Report consumer usage to Snowflake Marketplace in bulk by uploading a CSV file.
Overview
For metered (usage-based) listings, you report each consumer’s usage to Snowflake so it can be billed. Suger lets you submit usage for many entitlements at once by uploading a CSV — no need to call the API per consumer.
Upload CSV
- Open the Usage Records (metering) page.
- Click Batch Report to open the Batch Report Usage Records dialog.
- Click Choose File and select your usage CSV.
- Suger parses the file and previews the result in two tables:
- Valid Usage Records — records matched to an entitlement and dimension, with the calculated amount.
- Invalid Usage Records — records that could not be matched, each annotated with an error message (e.g.
buyer is not found,usage dimension is not found). You can download these to fix and re-upload.
- (Optional) Turn on Auto Fix to automatically map a record to the entitlement’s first available dimension when the supplied dimension does not match.
- Review the valid records, then click Batch Report to submit them.
CSV format
Each row is one usage record. The header row must include a column that identifies the consumer, plus dimension and quantity.
Identify the consumer with one of:
| Column | Description |
|---|---|
sugerBuyerId | Suger buyer ID |
sugerExternalBuyerId | Your external buyer ID |
customerId | Your customer ID stored on the buyer |
sugerEntitlementId | Suger entitlement ID |
sugerExternalEntitlementId | Your external entitlement ID |
Required usage columns:
| Column | Description |
|---|---|
dimension | The billable dimension / event key to charge against |
quantity | The number of units consumed (thousands separators like 12,238 are accepted) |
Records that share the same entitlement (and the same erpInvoiceID, if supplied) are grouped together and the quantities for each dimension are summed before reporting. Rows with the same entitlement but different erpInvoiceID values are reported as separate groups.