Amplitude Extract Authentication Guide

Amplitude Extract Authentication Guide


Overview

This is a step-by-step guide to acquiring credentials and authorising the Amplitude Extract connector for use in Matillion ETL.

Important Information

  • The Amplitude Extract connector uses an API token for third-party authentication.
  • While connector properties may differ between Cloud Data Warehouses, the authentication process remains the same.

Acquiring Third-Party Credentials

  1. Navigate to the Amplitude website and click Log In in the top right of the screen.

    Amplitude homepage

    Amplitude homepage

  2. On the next screen, enter the subdomain associated with the account in the field provided and click Log In. The browser will then redirect to a login screen. Enter valid login credentials for the account associated with subdomain to continue.

    Log in to organization

    Log in to organization

  3. Then, on the My Team Spaces dashboard, click Manage Data at the bottom of the sidebar on the left.

    Team Spaces dashboard

    Team Spaces dashboard

  4. The Manage Data page will open. From here, click Create Project in the top right of the screen.

    Manage Data page

    Manage Data page

  5. The Create New Project pop-up window will appear. Provide a name for the new project in the What's the name of your project field, then click Create.

    Create New Project

    Create New Project

  6. The browser will then redirect to the Advanced window of the newly created project. Then, click Project Settings on the sidebar on the left.

  7. In the Project Settings window, copy the codes under API Key and Secret Key as they will be required in Authorising for use in Matillion ETL.

    Please Note

    When copying the codes, some browsers may add a space to the end of the code. Watch out for this as it will cause the credentials to fail.

    Copy API Key and Secret Key

    Copy API Key and Secret Key


Authorising for Use in Matillion ETL

  1. In Matillion ETL, ensure an Orchestration Job is open on the job canvas. Then, if an Amplitude Extract connector is not already on the job canvas, search "Amplitude" using the Components search field, or find the Amplitude Extract connector under OrchestrationLoad/UnloadInternet, and drag it onto the job canvas.

    Please Note

    An Orchestration Job must be open on the job canvas within Matillion ETL to ensure the Amplitude Extract connector is searchable within the Components panel.

  2. Then, click and drag the Amplitude Extract connector onto the job canvas.

    Search for Amplitude Extract connector

    Search for Amplitude Extract connector

  3. Click the connector icon on the job canvas to open the Properties panel at the bottom of the screen.

  4. Then, click ... next to the API Key input.

    Open Amplitude Extract connector properties

    Open Amplitude Extract connector properties

  5. In the API Key pop-up window, paste the API Key (copied from the Amplitude website earlier) into the field provided and click OK.

    Paste the API Secret

    Paste the API Secret

  6. Click ... next to the Secret Key input. Then, in the Secret Key pop-up window, paste the Key Secret (copied from the Amplitude website earlier) into the Store in component field and click OK.

    Please Note

    Passwords and codes can also be saved using the Matillion ETL Password Manager. To learn how to do this, please refer to the Manager Passwords article.

    Paste the API Secret

    Paste the API Secret

  7. If the API Key and Key Secret are entered correctly, the connector should be authenticated and the status of the inputs will be displayed as OK.

    Connector successfully authenticated

    Connector successfully authenticated