Google Custom Search Query Authentication Guide

Google Custom Search Query Authentication Guide


Overview

This is a step-by-step guide to acquiring credentials and authorising the Google Custom Search Query connector for use in Matillion ETL.

Important Information

  • The Google Custom Search Query connector uses an API token for third-party authentication.
  • While connector properties may differ between Cloud Data Warehouses, the authentication process remains the same.
  • Please be aware, the use of some services with a Google Cloud Platform account may incur costs. For further information, please refer to Google Cloud Platform pricing.

Acquiring Third-Party Credentials

  1. Navigate to the Google Developers Console. The Google login screen will appear immediately. Enter valid login credentials to continue. The browser will then redirect to the API & Services dashboard. Click the project dropdown menu next to Google APIs in the top left of the screen.

    Please Note

    The menu should display the name of the currently selected project, i.e. <Project Name>. If there is no current project, the menu will read Select a project.

    Google API & Services page

    Google API & Services page

  2. The project window will pop up. Click NEW PROJECT in the top right of the window.

    Select a project window

    Select a project window

  3. On the New Project screen, provide details for the following fields:

    • Project name – provide a name for the project
    • Organisation – select an organisation to be associated with the app
    • Location – select a folder where the project will be stored, then click Create

    Selects Extras and then API keys

    Create new project

  4. The browser will return to the API & Services dashboard. Click Credentials on the sidebar. Then, in the Credentials window, click Create credentialsAPI key.

    API key credentials

    API key credentials

  5. A pop-up window will then appear with the new API key. Copy the API key from the field as it will be required in Authorising for use in Matillion ETL.

    Copy API key

    Copy API key


Authorising for Use in Matillion ETL

  1. If a Google Custom Search Query connector has not already been dragged onto the job canvas, search "Google Custom Search" using the Components panel search field, or find the Google Custom Search Query connector under OrchestrationLoad/UnloadInternet.

    Please Note

    An Orchestration Job must be open on the job canvas within Matillion ETL to ensure the Google Custom Search Query connector is searchable within the Components panel.

  2. Then, click and drag the Google Custom Search Query connector onto the job canvas.

    Search for Google Custom Search Query connector

    Search for Google Custom Search Query 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 Google Custom Search Query connector properties

    Open Google Custom Search Query connector properties

  5. In the API Key pop-up window, paste the API key (copied from the Google Developers Console earlier) into the field provided and click OK.

    Paste API Key

    Paste API Key

  6. If the API Key is entered correctly, the connector should be authenticated and the status of the input will be displayed as OK.

    Connector successfully authenticated

    Connector successfully authenticated