Twitter (X) Query authentication guide

This is a step-by-step guide to acquiring credentials for authorizing the Twitter Query and Twitter Ads Query components for use in Matillion ETL.

• The Twitter Query and Twitter Ads Query connectors use OAuth for third-party authentication.
• While connector properties may differ between cloud data warehouses, the authentication process remains the same.
• Twitter (X) accounts need to apply for authorization to develop apps. If the associated account hasn't yet been authorized, be aware that the authorization process may take some time and is unfortunately outside of Matillion's control.

Note

Twitter is now known as X, and will be referred to as such in the following steps.

---

Prerequisites

1. Begin by creating an OAuth entry in Matillion ETL, as described in Manage OAuth.
2. Note the Callabck URL, as you will require this when obtaining the X credentials as described below.
3. You should complete the configuration of this OAuth entry using the X credentials, obtained as described below.

---

Acquiring X credentials

To authenticate with X, you need to create an app in the X Developer Portal.

1. Log in to the X Developer Portal. The Dashboard page will be displayed.
2. Click Projects & Apps → Overview in the left-hand menu.
3. Scroll down to the bottom of the Overview page and click + Create App.
   • If this is the first time you are creating an app, the + Create App button will be situated at the top of the Overview page.
   • There is a maximum quota of apps that can exist at any time. If you have already met your quota, you must delete an existing app before you can create a new one.
4. Enter a suitable name for the app, then click Next.
5. Select OAuth 1.0a as your user authentication method.
6. Select Read and write from the App permissions section.
7. Add a Callback URI/ Redirect URI, and paste the Callback URL copied from the Manage OAuth dialog in Matillion ETL.
8. Enter http://www.matillion.com as the Website URL.

9. Other app details (icon ,description, etc.) are optional and can be completed if desired.

   Note

   It's your responsibility to ensure you are in compliance with X's Developer terms when entering these details.

10. Click Save.

11. Copy the Access Token and Secret values. These credentials are required to complete the Client ID and Client Secret properties of the OAuth in Matillion ETL. The Secret can never be viewed again after you leave this screen, so you must copy it immediately.