Monitoring billing for tenants

All tenants are billed as part of their Identity Platform project. This document explains how to export billing data and monitor the cost of individual tenants.

Before you begin

To export tenant billing data, you'll need to be granted the IAM Owner role ( roles/owner ) on the following:

• An Identity Platform project with multi-tenancy enabled.
• The billing account linked to your project.

Enabling billing export to BigQuery

To make billing data available in BigQuery, follow the steps in Export billing data to BigQuery .

You only need to complete the step once per project.

Querying billing data

1. Open the BigQuery page in the Google Cloud console. Go to the BigQuery page

2. Select the table containing your project's billing information.

3. Click Compose Queryto open the query editor.

4. Enter a query.

   To list the total cost for each tenant, use the following, replacing dataset-name.table-name with the name of the billing dataset and table you exported in step 1:

     SELECT 
     
    labels 
    . 
    value 
     
    as 
     
    Tenant 
    , 
     
    SUM 
    ( 
    cost 
    ) 
     
    as 
     
    TenantCost 
    FROM 
     
    [ 
    dataset 
    - 
    name 
    . 
    table 
    - 
    name 
    ] 
    WHERE 
     
    labels 
    . 
    key 
     
    = 
     
    "goog-identitytoolkit-tenant" 
    GROUP 
     
    BY 
     
    1 
    
   

   All monthly active user reports have a start time at the beginning of the month. You can use WHERE usage_start_time and the first day of the month (expressed in Pacific Time) to filter on a monthly basis. For example, to list the cost of each tenant for August 2019:

     SELECT 
     
    labels 
    . 
    value 
     
    as 
     
    Tenant 
    , 
     
    SUM 
    ( 
    cost 
    ) 
     
    as 
     
    TenantCost 
    FROM 
     
    [ 
    dataset 
    - 
    name 
    . 
    table 
    - 
    name 
    ] 
    WHERE 
     
    labels 
    . 
    key 
     
    = 
     
    "goog-identitytoolkit-tenant" 
    AND 
     
    usage_start_time 
     
    = 
     
    "2019-08-01 00:00:00 -07:00" 
    GROUP 
     
    BY 
     
    1 
    
   

   You can also get the costs for one specific tenant. Replace tenant-id with the ID of your tenant in the following example:

     SELECT 
     
    labels 
    . 
    value 
     
    as 
     
    Tenant 
    , 
     
    SUM 
    ( 
    cost 
    ) 
     
    as 
     
    TenantCost 
    FROM 
     
    [ 
    dataset 
    - 
    name 
    . 
    table 
    - 
    name 
    ] 
    WHERE 
     
    labels 
    . 
    key 
     
    = 
     
    "goog-identitytoolkit-tenant" 
    AND 
     
    labels 
    . 
    value 
     
    = 
     
    "tenant-id" 
    GROUP 
     
    BY 
     
    1 
    
   

5. Click Run queryto execute it.

You should see a billing breakdown specific to one particular tenant.

What's next

• Learn more about billing on Google Cloud .
• See pricing for Identity Platform .