Skip to content

SendGrid Query authentication guide

This is a step-by-step guide to acquiring credentials for authorizing the SendGrid Query component for use in Matillion ETL.

  • The SendGrid Query connector uses either a username and password or an API key for third-party authentication. This guide will only explain the API token method.
  • While connector properties may differ between cloud data warehouses, the authentication process remains the same.

Create an OAuth entry

Begin by creating an OAuth entry in Matillion ETL, as described in Manage OAuth. You should then configure this OAuth entry using the SendGrid credentials, obtained as described below.

Obtain a SendGrid API key

  1. Log in to https://app.SendGrid.com.
  2. Click Settings → API Keys.
  3. Click Create API Key.
  4. Provide a unique, descriptive name for API key.
  5. Set the API key permissions.
  6. Click Create & View. Your browser will refresh and load a page that displays your API key.

  7. Copy the API token immediately—it is only viewable once.

    Warning

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

  8. Click Done.

  9. Navigate to your SendGrid Query component in Matillion ETL.
  10. Ensure Authentication Method is set to API Key.
  11. Click into the API Key property. Paste your API key (copied from the SendGrid website earlier) into the Store in component field and click OK. Alternatively, click Manage and create a password entry in Manage Passwords and then click the Use Password Manager radio button and select your new entry from the drop-down.
  12. If the API key is entered correctly, the connector should be authenticated.