github_copilot_billing_usages

Usage-based billing for GitHub Copilot per organization or enterprise per day, broken down by SKU.

id

Primary key
Unique identifier for the row

enterprise_slug

string
GitHub Enterprise slug (set for enterprise-scoped rows)

organization_id

Foreign key
ID of the GitHub organization (set for organization-scoped rows)

organization_name

string
Organization name from the billing API; identifies the org within an enterprise (set on billing usage rows and on AI credit usage rows sourced from the usage report export)

repository_name

string
Repository the usage is attributed to; blank for org/enterprise-level SKUs and AI credit usage rows

model

string
AI model the usage is attributed to (AI credit usage rows); blank for non-AI-credit SKUs

login

string
GitHub login for user-level AI credit usage rows; blank for non-user (billing) rows

user_id

Foreign key
ID of the matched GitHub user, resolved from login (best-effort; null when unmatched)

day

date
Date of the usage record

product

string
GitHub product the usage belongs to (always Copilot for stored rows)

sku

string
Billing SKU identifier

unit_type

string
Type of billing unit

price_per_unit

number
Price charged per unit

quantity

number
Quantity of the billed unit (net quantity for AI credit usage rows)

gross_quantity

number
Gross quantity before discounts (AI credit usage rows only)

discount_quantity

number
Discounted quantity (AI credit usage rows only)

net_quantity

number
Net quantity after discounts (AI credit usage rows only)

gross_amount

number
Total billing amount before discounts

discount_amount

number
Total discount amount applied

net_amount

number
Net billing amount after discounts