Allowing Integrate.io ETL access to my data on Google Cloud Storage

Integrate.io ETL uses Service Account Key to connect to your Google Cloud Storage. This article discusses providing Integrate.io ETL access to your Google Cloud Storage and then details creating a Google Cloud Storage connection in Integrate.io ETL.

 

Service Account Creation & JSON Key Generation

  1. Access your Google Cloud Console and click the relevant project.
  2. On the sidebar, choose IAM & Admin -> Service Accounts -> Create Service Account
  3. Fill up Service account name and then click Done.

    thumbnail image
  4. Click the newly created service account and navigate to Keys.
  5. Generate a JSON key via Add Key -> Create New Key -> JSON - > Create.
  6. We will upload this JSON key later on Integrate.io ETL when creating the connection.

Grant Access to Cloud Storage Bucket

  1. Access your Google Cloud Storage and click the relevant bucket.
  2. Under Permissions section, click Grant Access.
  3. Input the service account email we created from the previous section under New Principals field
  4. For Read-only, select the following roles: Storage Legacy Bucket Reader and: Storage Legacy Object Reader
  5. For Write access, select the following roles: Storage Legacy Bucket Writer and: Storage Legacy Object Reader
  6. Click Save.

    thumbnail image

Create a Google Cloud Storage connection in Integrate.io ETL

  1. Click the Connections icon (lightning bolt) on the top left menu.
  2. To create a connection, click New connection.thumbnail image
  3. Choose Google Cloud Storage.thumbnail image
  4. Name the connection. Upload JSON key.thumbnail image
  5. Click Test Connection to make sure the connection details are correct.
  6. Click Create connection to create the connection.thumbnail image thumbnail image