Push-to-Warehouse Setup: Google Cloud Storage

📘

In this guide, you will be setting up a connection to a data warehouse destination you own. Reach out to your Customer Success Manager or [email protected] to confirm that your Modern Treasury plan includes the Push to Warehouse capability.

Prerequisites

• Please reference our Push to Warehouse IP Address documentation.

Step 1: Create a service account

1. In the GCP console, navigate to the IAM & Admin menu.
2. Click into the Service Accounts tab.
3. Click Create service account at the top of the menu.
4. In the first step, name the service account that will be used to transfer data into Cloud Storage and click Create and Continue. You may continue through the following steps without assigning any roles, and in the final step, click Done.

Step 2: Create destination GCS bucket

1. Navigate to the Cloud Storage page.
2. Click Create.
3. Enter a bucket name, choose a region. Note: at the Choose how to control access to objects step, we recommend selecting Enforce public access prevention on this bucket.

4. After choosing your preferences for the remaining steps, click Create.
5. On the Bucket details page for the bucket you created, select the Permissions tab, and click Grant access.
6. Grant access to the principal (Service Account) you created in Step 1, and assign the Role: Storage Object Creator. Click Save.

Step 3: Generate HMAC key

An HMAC key is a type of credential and can be associated with a service account or a user account to access Google Cloud Storage.

1. Navigate to the Cloud Storage page.
2. Click into the Settings tab on the left side menu.

3. Navigate to the Interoperability tab and click the Create a key for a Service Account button.
4. Select the Service Account created in Step 1, and click Create key.

5. Make a note of the Access key and Secret.

Step 4: Add your destination

Securely share your bucket name, your chosen folder name for the data, and your bucket secret key with us to complete the connection.