Twilio Query authentication guide

Overview

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

Important Information

• The Twilio 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.

---

Acquiring Third-Party Credentials

1. Navigate to the Twilio website, then click LOG IN. The browser will redirect to a sequence of login screens. Enter valid login credentials to continue.

   

   Twilio homepage

2. Once logged in, the Twilio developer console will open on the dashboard of the most recently accessed project. To use a different project, click next to the <Project Name> in the top left of the screen, and Click the relevant project.

   Please Note

   To create a new project, click Create New Project at the bottom of the project menu, then follow the prompts to add products, give the project a name and invite teammates. After creating the new project, the browser should redirect to the new project's dashboard.

   

   Project console dashboard

3. On the dashboard of the selected project, find the Project Info block. Copy the codes next to ACCOUNT SID and AUTH TOKEN as they will be required in Authorising for use in Matillion ETL.

   Please Note

   In order to copy the AUTH TOKEN, view must first be clicked to make it visible.

   

   Copy ACCOUNT SID and AUTH TOKEN

---

Authorising for Use in Matillion ETL

1. If a Twilio Query connector has not already been dragged onto the job canvas, search "Twilio" using the Components panel search field, or find the Twilio Query connector under Orchestration → Load/Unload → CRM & Marketing Automation.

   Please Note

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

2. Then, click and drag the Twilio Query connector onto the job canvas.

   

   Search for Twilio Query component

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

4. Click ... next to the Account SID input.

   

   Open Twilio Query connector properties

5. In the Account SID pop-up window, paste the ACCOUNT SID (copied from the Twilio website earlier) into the field provided and click OK.

   

   Paste the ACCOUNT SID

6. Next, click ... next to the Authentication Token input. Then, in the Authentication Token pop-up window, paste the AUTH TOKEN (copied from the Twilio 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 AUTH TOKEN

7. If the ACCOUNT SID and AUTH TOKEN are entered correctly, the connector should be authenticated and the status of the inputs will be displayed as OK.

   

   Component successfully authenticated