Cloud Credentials
  • Dark
    Light

Cloud Credentials

  • Dark
    Light

Overview

You will require credentials to connect to certain destinations. AWS, GCP, and Azure each require valid user credentials in order to successfully create a destination. You can view and create saved credentials through the Manage - Credentials interface.

The following guide explains how to view and manage your cloud credentials in Matillion Data Loader, as well as a basic example of how to create one.

You can view and manage your passwords from the Manage - Credentials tab.

From here you can view all of your stored credentials. Credentials are organised in tabs according to their respective service.

You can edit a set of credentials by clicking the pencil icon next to it. You can permanently delete a set of credentials by clicking the trashcan icon next to it.

Create Cloud Credentials

You cannot create credentials as part of the destination configuration process. You will need to create them before you create a pipeline, using the Manage - Credentials interface.

To create a new set of cloud credentials, select the appropriate tab and click the Add... button at the bottom of the window. The required steps to create each type of cloud credentials are described below.

AWS

AWS credentials are needed for Matillion Data Loader to access different services, such as S3 staging buckets, and for listing Redshift clusters.

The instance credential is the Matillion credential used to encrypt and decrypt passwords by KMS service. Matillion Data Loader uses credentials to access AWS S3.

For AWS Credentials, you are required to enter the following for an existing Amazon IAM user:

  • AWS credential label: Give your set of credentials a clear and descriptive name. This is how they're referred to throughout Matillion Data Loader.
  • Access Key ID: Enter the required Access Key ID from your S3 account.
  • Secret Access Key: Enter the required Secret Access Key from your S3 account.

Please refer to the following Amazon help page for more information about access and secret access keys.

You can Test credentials to confirm that the details are correct at any point. Click Test and save to test the credentials and return to the Manage Cloud Credentials page. If successful, your credentials will be saved and stored in Matillion Data Loader. If unsuccessful, you will not be able to continue.

GCP

Google Cloud Platform credentials will be necessary for accessing BigQuery and Google Cloud Storage for staging.

For GCP credentials, you are required to enter the following:

  • GCP credential label: Give your set of credentials a clear and descriptive name. This is how they're referred to throughout Matillion Data Loader.
  • Access Key ID: Upload a JSON file no larger than 1 MB containing your Service Account File. You can drag-and-drop the file directly into the entry field or click the field to open a file browser.

Azure

For Microsoft Azure credentials, the relevant information can be found in the following places while logged into your Azure portal:

  • Azure credential label: Give your set of credentials a clear and descriptive name. This is how they're referred to throughout Matillion Data Loader.
  • Tenant ID: (AKA Directory ID) Azure Active Directory → Properties → Directory ID
  • Client ID: (AKA Application ID) Azure Active Directory → App Registrations → Registered App → Application ID
  • Secret Key: Azure Active Directory → App Registrations → Registered App → Settings → Keys

You can Test credentials to confirm that the details are correct at any point. Click Test and save to test the credentials and return to the Manage Cloud Credentials page. If successful, your credentials will be saved and stored in Matillion Data Loader. If unsuccessful, you will not be able to continue.

For more information on Azure credentials, click here.


What's Next