Google Cloud Storage

In this doc, we will cover how to setup a Connection to Google Cloud Storage.

Prerequisites

  • Access credentials
  • Data location on Google Cloud Storage
  • Data Schema (column names and column type)

Create a New Google Cloud Storage Connection

Figure 1Figure 1

Figure 1

Figure 2Figure 2

Figure 2

*Fields denoted with a blue dot are required**

  • CONNECTION NAME: The name to identify the connection.
  • PROJECT: The name to identify the project.
  • BUCKET: Google Cloud Storage bucket where the data is located, such as new-york-weather-data-20210318.
  • REQUIRES CREDENTIALS: If de-selected, only the publicly accessible buckets can be accessed.
  • CHOOSE CREDENTIALS: Choose from an existing credential or create new credential for connecting to Google Cloud Storage if the Required Credentials checkbox is selected. When creating a new connection that requires credentials, access the drop down to select an existing credential or a new credential. The new credential will require Viewer level access or higher in GCS. Although higher permissions will result in a successful connection, keep best practices in mind and adhere to the principle of least privilege.
Figure 3Figure 3

Figure 3

  • CREDENTIAL NAME: The name to identify the credential.
  • CREDENTIAL TYPE: Google Cloud Storage.
  • GOOGLE CLOUD CREDENTIALS: Private key used to identify the Google Cloud Storage account. When a Service Account is created a private key is produced to provide authentication between Google Cloud and third party platforms. In the GOOGLE CLOUD CREDENTIALS field enter the private key for the selected service account. The private key will be a block of JSON, provide the entire key which includes the type, project_id, private_key_id, private_key, client_email, client_id, auth_uri, token_uri, auth_provider_x509_cert_url and client_x509_cert_url. Keep in mind that Google Service Accounts are bound to a project. Each Google project will require a new credential object.

Use TEST CONNECTION button to check whether credentials are correctly configured and If SUCCESS, click CREATE AND USE CONNECTION.


Did this page help you?