This section describes the configuration and input information needed to connect Google billing data to Flexera One using BigQuery billing exports. The following steps must be completed to connect your Google cloud billing data to Flexera One for cost reporting purposes:
| • | Enable Billing Data Export to BigQuery in Google Compute Engine |
| • | Determine ID of the Google Billing Account That Pays for This Bill’s Google Cloud Platform Resources |
| • | Allow Flexera One to Access the BigQuery Dataset Using a Service Account |
For instructions on how to add or update billing information, see Adding Billing Data or Updating Billing Data Configurations. For instructions on connecting your cloud accounts to Policies, see Managing Credentials for Policy Access to External Systems.
Enable Billing Data Export to BigQuery in Google Compute Engine
Flexera One consumes Google billing data via the BigQuery export method in Google. (See Google’s “Export Cloud Billing Data to BigQuery” documentation for details.) This feature can be enabled in Google Compute Engine (GCE) for each billing account and will contain data for all projects in that billing account.
Important:Flexera One uses BigQuery billing data as the source for billing information because the data is more complete. (See Google’s “Export Cloud Billing Data to BigQuery” documentation for details.) The estimated cost for BigQuery for billing purposes is no more than $100/yr for extremely large usage amounts (lesser usage will incur less cost). In some cases, the cost will be $0 as the entire usage will fall in the free tier of BigQuery.
If you have already configured billing export to BigQuery, ensure you have the Dataset ID and Project that contains the dataset, and proceed to the next step.
If you need to configure data export to BigQuery, follow the instructions provided by Google for your Google billing accounts. Take note of the Dataset ID when you create the dataset as well as the Project in which the dataset exists.
Note:The Dataset ID is sometimes shown prepended with the project ID. For example, project_id:dataset_id. In this case, ensure you submit only the Dataset ID when registering your bill.
Determine ID of the Google Billing Account That Pays for This Bill’s Google Cloud Platform Resources
A Cloud Billing Account is a Google construct for managing usage and billing records for Google Cloud Platform resources paid for by a common entity. For more information on Google Cloud Billing Accounts, see the Google Cloud Platform documentation, Overview of Cloud Billing Concepts.
Allow Flexera One to Access the BigQuery Dataset Using a Service Account
After your billing data is being exported to BigQuery, Flexera One needs access to the BigQuery dataset to read the data. The Flexera One platform uses a Google service account to gain access to the BigQuery dataset.
Create or identify the Google service account you want to use to gain access to the BigQuery dataset. You must have access to the JSON private key for the service account as well as the service account ID. Refer to Google’s documentation on creating a Google service account and creating service account keys for instructions.
After you have determined the service account you would like to use, the following steps must be completed:
| • | In Google Cloud Platform, grant project-level IAM roles in Google Cloud Platform for the service account in the project that contains the billing BigQuery dataset. Roles required: BigQuery Data Viewer and BigQuery Job User. BigQuery Data Viewer is required to read data from the specified dataset. BigQuery Job User is needed to create query jobs from which the results can be read. (Currently 2 jobs per day are created.) |
| • | In Google’s BigQuery, share the dataset with the service account. The BigQuery dataset must explicitly be shared (view access) with the service account. |
| a. | To submit Google billing data to Flexera One, see Using API for Bill Connects. |