Configuring Google Cloud Platform for Imports (Service Account Key Setup)
You can configure your Google Cloud Platform account to import data into InfoSum Platform using the Google Cloud Storage ICC.
This article describes step-by-step how to configure your Google Cloud Platform account to import data into InfoSum Platform using the Google Cloud Storage ICC.
Note: InfoSum does not support Google Cloud Storage (GCS) parallel composite uploads or Workload Identity Federation for data imports.
Note: The below instructions can also be used for exporting data to a GCS Destination.
First, you will need a Google Cloud Platform account. To set up an account, or access an existing account, go to the URL: console.cloud.google.com
Once you have created your Google Cloud Platform account, you will need to do the following to import into InfoSum Platform:
- Create a project
- Create a bucket for your project
- Create a service account for your project
- Associate a key with a service account
- Complete the Infosum Google Cloud Storage data connector fields
The sections below describe the steps to do this.
Creating a project
Go to the console.cloud.google.com URL for your account.
Select Browser and click the New Project button in the Menu bar. Alternately, select a project and click the New Project button in the dialog box that opens.
The new project window opens, where you can change the new project name and browse and select the location of an associated Google organization.
Note: personal accounts cannot be associated with a Google organization.
Click the Create button to create the project.
Next, you will need to create a bucket for your project.
Creating a bucket for your project
Select Browser from the Cloud Storage menu for your newly-created project.
Select Create Bucket.
Enter a name for the bucket from the window that opens.
Click Continue to select the location to store your data depending on where you are.
Select the location type and location, for example, Multi-region and EU.
Note: You can see a breakdown of monthly cost estimates in the right-hand pane of the window.
Click Continue and select the default storage for your data. This can be left as Standard.
Click Continue and choose how to control access to objects, which can be left as is.
Click Continue to open advanced settings, which can be left as is.
Click Create and the bucket and its selected settings appear in the Browser list.
Click on the bucket to open the details window, where you can drag and drop files into the bucket.
Next, you will need to create a service account. This account is used to create the JSON file for the Google Cloud Platform ICC file drop that you will see on the InfoSum Platform, here:
Creating a service account for your project
Select Service Accounts from the IAM & Admin menu in the Google Cloud Platform.
Select Create Service Account.
This opens the window shown below. Give the service account a name - this name is used to auto-complete the randomly generated Service account... field underneath.
Click Create and Continue to create the account and grant service account access to the project.
Select the Storage Object Viewer role or above to be able to use this account. Storage Object Viewer is the lowest level role that can use this service account.
Click Continue to grant specific users access to this account. There is no need to add any users here because when you create the account, the JSON file is downloaded to your computer and can be given to any users that need it.
Click Done and the account appears in the list of Service Accounts.
Next, you will need to associate a key with the account as it has no keys.
Associating a key with a service account
Select Manage Keys from the Actions menu for the newly-created service account.
Select Create new key from the Add Key menu to create a new key for this account.
The Create private key dialog box opens.
Select JSON as the key and click Create.
Note: InfoSum Platform only accepts JSON keys.
The following message appears after the JSON file is downloaded to your computer:
Click Close. If you go to the list of service accounts, the newly-created service account now shows the key associated with this account.
You will get a JSON key file, which contains the project ID, private ID, full private ID, client email, client ID, and authorization/token URLs.