4.5 Google Cloud Platform service account file

This exercise will guide you through setting up Google Cloud Platform integration in Mage Pro by configuring service account credentials and updating your connection settings. This process enables your pipelines to securely connect to BigQuery, Google Cloud Storage, and other GCP services.

Prerequisites

Before starting this exercise, ensure you have:

• A GCP service account with appropriate permissions for your intended services (BigQuery, Cloud Storage, etc.)

• The service account JSON key file downloaded from the Google Cloud Console

• Access to your Mage Pro workspace with file upload permissions

Step 1: Upload the GCP service account file

Navigate to your project structure:

• Open your Mage Pro workspace in your browser

• In the left file browser, locate your project root directory

• Create a secure location for credentials by right-clicking and selecting "New folder"

• Name the folder credentials or config to keep sensitive files organized

Upload your service account file:

• Right-click inside the credentials folder

• Select "Upload file" from the context menu

• Choose your GCP service account JSON file (typically named something like your-project-service-account.json)

• Verify the upload completed successfully by seeing the file appear in the directory

• Add the credentials folder to your .gitignore file to prevent committing sensitive files to version control

Note the file path: Your uploaded file will be accessible at: /home/src/your-project-name/credentials/your-service-account.json