Billing Data Access Role
The following process allows to:
Billing data access role
Create an IAM Service Account User
Enable Billing Account Access
Enable Billing Export
To access billing data tables a role, a user must exist within the master APTARE project. Typically, an administrator user of an individual project will not have permissions to create roles who can access Billing Data records.
Select the Aptare Connector Project.
Select IAM & ADMIN > Roles.
Choose CREATE ROLE.
Specify title and description.
Select General Availability.
Click Add Permissions.
Specify bigquery in the Filter permission by role field to find and add the following permissions.
bigquery.datasets.get
bigquery.jobs.create
bigquery.tables.get
bigquery.tables.getData
bigquery.tables.list
Create an account used to access GCP from the connector.
Select the previously created Aptare Connector project.
Navigate to IAM & Admin > Service Accounts.
Choose CREATE SERVICE ACCOUNT.
Specify the required details and click CREATE.
Choose the Aptare Connector Read Only.
Click ADD ANOTHER ROLE and select the Aptare Billing Read Only.
Click CONTINUE.
Click CREATE KEY and choose the default JSON format.
A .JSON file will be downloaded.
Click CLOSE.
The service account needs access to list the available billing accounts.
Navigate to Billing > Manage Billing Accounts.
Select the box next to the billing account which opens the permissions panel on the right side.
Click Add Members.
Specify email address for the service user account.
Choose the Billing Account Viewer role.
Click Save.
To collect billing data, the billing account needs to be exported to the 'Aptare Collector Project' using a BigData table.
Following is the procedure to enable billing export option.
Navigate to (Big Data) BigQuery
Under resources, select aptare-connector.
Choose Create Dataset on the right panel.
Specify title and click Create Dataset.
From the main menu, select Billing.
Link the project to a Billing Account.
Select Billing Export from the menu item.
Select BIGQUERY Export option.
Select the project and the data set.
Click SAVE
