Skip to content
mofcloud

Google Cloud

Last updated:

1. Google Cloud Service Account Setup For Mofis

Section titled “1. Google Cloud Service Account Setup For Mofis”

Create a Google Cloud service account with BigQuery Job User and Cloud Asset Viewer roles. Follow the steps to generate and securely store a JSON private key.

Steps (15)
  1. Select preferred project in GCP console. Then, open “IAM & Admin” to manage service accounts.
  2. Open “Service Accounts”.
  3. Choose “Create service account”.
  4. Enter “bill-export” in “Service account name”.
  5. Choose “Create and continue” to configure permissions.
  6. Open “Select a role” and search for “BigQuery Job User”.
  7. Select “BigQuery Job User” to allow running jobs.
  8. Select “Cloud Asset Viewer” for read-only access to asset metadata.
  9. Choose “Continue” to apply the selected roles.
  10. Leave optional principals empty and choose “Done”.
  11. Open the “bill-export” service account.
  12. Open the “Keys” tab.
  13. Choose “Create new key”.
  14. Keep “JSON” selected and choose “Create” to download the private key.
  15. The private key is saved. Store it securely, then choose “Close”.

2. Google Cloud Billing Export to BigQuery

Section titled “2. Google Cloud Billing Export to BigQuery”

Walk through creating a BigQuery dataset, granting a service account viewer access, and configuring standard billing export in Google Cloud.

Steps (22)
  1. Open the project selector to confirm the project for this setup.
  2. Open “IAM & Admin” to find the service account.
  3. Copy the bill-export service account address for reuse.
  4. Open “BigQuery” to create the billing export dataset.
  5. Open “Datasets” for the selected project.
  6. Choose “Create dataset”.
  7. Enter “bill_export_mofis” as the “Dataset ID”.
  8. Click “Create dataset” to create the export destination.
  9. Click “Refresh” to show the newly created dataset.
  10. Open the dataset actions menu to configure access.
  11. Choose “Manage permissions” from the “Share” submenu.
  12. Click “Add principal” to grant the service account access.
  13. Paste service account ID copied in the previous steps.
  14. Open “Select a role” to choose dataset access.
  15. Choose “BigQuery Data Viewer” for read access to the dataset.
  16. Search for “Billing” in the console search bar.
  17. Select “Billing” from the search results.
  18. Open “Billing export” to configure the BigQuery destination.
  19. Click “Enable standard export” under “Standard usage cost”.
  20. Open “Projects” to choose the project containing your dataset.
  21. Choose “bill_export_mofis” from the loaded datasets.
  22. Click “Save” to submit the billing export configuration. It needs couple of hours, sometimes 24 hours for GCP to export billing data into Big Query.

Follow the setup of a Google Cloud billing connection in Mofis using a service account key and billing export details. Monitor synchronization, then select the connected account in Smart Bills.

Steps (11)
  1. Select Google Cloud to add a billing account.
  2. Enter your preferred name in “Account name” to identify this connection.
  3. Use “Choose JSON file” to open your Google Cloud service account key.
  4. The key is recognized, and “Billing project ID” is populated.
  5. Enter your billing export table in “Table name”.
  6. Select “Create” to add the Google Cloud account.
  7. Open “Data Sync” to monitor the new account’s billing synchronization.
  8. Expand the “gcp-test” task to inspect synchronization progress.
  9. Synchronization succeeded. Open “Smart Bills” to review billing data.
  10. Open the account selector to switch the billing view.
  11. Select “gcp-test” as the account for Smart Bills.