We're using Matillion ETL for Redshift and are trying to transfer a file from our S3 bucket to a GCP account. We were given service account information but we're stuck on how to allow the connection between our AWS account and GCP

Matillion ETL
1

We’re using Matillion ETL for Redshift and are trying to transfer a file from our S3 bucket to a GCP account. We were given service account information but we’re stuck on how to allow the connection between our AWS account and GCP.

2

Hi @bdoucet1574197038239​

There are two docs that cover this topic well.

  • Environments->Cloud platform connection
    • Shows where to configure GCP credentials
    • This may be all that's needed if the credentials you've been given already have sufficient permissions to write files where required.
  • IAM Roles & Permissions (GCP)
    • Geared toward BigQuery versions of METL but highlights the needed permissions for accessing various services. For your purpose, the storage permissions are relevant.

Once you have installed credentials and have selected them for use in the desired Environment(s), you will use a Data Transfer component to configure and orchestrate the copy.

Hope this helps.

Cheers,

Chika