3.3 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

• From the Mage Pro homepage, navigate to the file editor page by hovering over the left popout navigation menu, and click “Editor”

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

• This should be /home/src/your-project-name

Upload your service account file:

• Right-click on the project 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 file 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/your-service-account.json