BigQuery

This chapter describes how to link BigQuery as an external data source to the Morph platform.

Setup

First, select Connections at the top of the screen and press the Create button.

The Create connection side panel appears on the right-hand side of the screen, where you can select BigQuery.

The connection information entry screen will appear as shown below. Items marked with (*) must be entered.

Authentication method

There are two authentication methods that can be used to connect to BigQuery: 'OAuth2' and 'Service Account'. Each method is suitable for different use cases.

OAuth2 authentication

OAuth2 is an industry-standard protocol for secure third-party authentication. This method allows users to securely grant data access without directly exposing their BigQuery account credentials. The process requires the user to set up an OAuth client within BigQuery and provide its client ID and secret to Morph. This allows secure data access via the API.

Service Account authentication

Service Account authentication is used when an automated process or system service accesses a database without human intervention; set up a Service Account in BigQuery and provide the username and password (or private key) for that account in the Morph settings. This allows scripts and back-end applications to manipulate the database directly and securely.

These authentication methods make the connection to BigQuery more secure and flexible, allowing data access according to the needs of different applications.

BigQuery integration using OAuth2 authentication

1. select 'OAuth2' in the Morph settings and authenticate with your Google account using the 'Sign in with Google' button.
2. when you are redirected from Sign in with Google to the Google Cloud Platform side screen, allow the Morph connection request. If you allow it, you will be redirected to the Morph screen and the configuration is complete.

BigQuery integration using Service Account

Configuration steps:.

1. create a Service Account on Google Cloud Platform and obtain its JSON key. [Ref: Create and manage Service Account keys (opens in a new tab)]
2. select 'Service Account' in the Morph settings and upload the downloaded JSON key to the field you specify.

Completing the connection

After completing the Account section and pressing the Create button at the bottom left of the screen, next enter the Connection slug to complete the connection settings.

Connection slug: Uniquely identifies the connection to the external data source and cannot be empty. Set arbitrarily using only letters, numbers and underscores.

When the connection settings appear in the Connections list, the configuration is complete.