2.16 Marketplace Purchases

2.16.1 Description

2.16.2 Directly Dependent Columns

2.16.3 Supporting Columns

2.16.4 Example SQL Query on a CSP Marketplace Using the Cost and Usage FOCUS Dataset

Example SQL Query on a CSP Marketplace Using the Cost and Usage FOCUS Dataset

SELECT
  ServiceProviderName,
  InvoiceIssuerName,
  BillingPeriodStart,
  BillingPeriodEnd,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ServiceProviderName = '<Example SaaS Provider>'
  AND InvoiceIssuerName = '<Example CSP Marketplace>'
GROUP BY
  ServiceProviderName,
  InvoiceIssuerName,
  BillingPeriodStart,
  BillingPeriodEnd

2.16.5 Example SQL Query on a Provider Using the Cost and Usage FOCUS Dataset

Example SQL Query on a Provider Using the Cost and Usage FOCUS Dataset

SELECT
  ChargePeriodStart,
  ChargePeriodEnd,
  ResourceId,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE InvoiceIssuerName = '<Example CSP Marketplace>'
GROUP BY
  ChargePeriodStart,
  ChargePeriodEnd,
  ResourceId