Setup Zuora Connector for Google Cloud Storage

Step 1: Create a service account

1. In the GCP console, navigate to the IAM and Admin menu, click into the Service Accounts tab, and click Create service account at the top of the menu.
2. In the first step, name the service account that will be used to transfer data into Cloud Storage and click Create and Continue. Click Continue in the following optional step without assigning any roles.
3. In the Grant users access to this service account step, within the Service account users role field, enter the provided Service account (see prerequisite) and click Done.
4. Once successfully created, search for the created service account in the service accounts list, click the Service account name to view the details, and make a note of the email (note: this is a different email than the service's service account).
5. Select the permissions tab, find the provided principal name (Service account from the prerequisite), click the Edit principal button (pencil icon), click Add another role, select the Service Account Token Creator role, and click Save.

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 (this is the service account you created, not the service account from the prerequisite), and assign the Role: Storage Legacy Bucket Writer > click Save.
   • 

Step 3: Add your destination

1. After completing the initial setup, share your bucket name with a Zuora representative who will create a connection link for you.
2. Using the connection link shared with you by Zuora, you can securely input your Google Cloud Storage details, including the folder and bucket name, choose the auth method, and input the required credentials, finalizing the setup for the connection.
3. After you fill in all the required Google Cloud Storage details through the provided link and test the connection, saving the destination will kickstart the onboarding process and begin transferring data.

Format of Transferred Data

When transferring data to Google Cloud Storage, the files are saved in Apache Parquet format, following an Apache Hive partitioning style. The data organization structure is detailed below:

<bucket_name>/<folder_name>/<model_name>/dt=<transfer_date>/<file_part>_<transfer_timestamp>.parquet

where:

• <bucket_name> and <folder_name> are provided during destination configuration.
• <model_name> is the name of the data model being transferred (this is equivalent to a table name in relational data destinations).
• <transfer_date> and <transfer_timestamp> are generated at transfer time and based on the transfer's start time. <transfer_date> is of the form 2006-01-01, while <transfer_timestamp> is of the form 20060102150405.
• <file_part> is a monotonically increasing integer for a given timestamp, and does not carry any special meaning.