Facebook Authentication Guide
  • Dark

Facebook Authentication Guide

  • Dark


This is a step-by-step guide to acquiring third-party credentials for authorizing the Facebook Query and Facebook Ads Query connectors for use in Matillion ETL.

These connectors use an OAuth for third-party authentication. OAuth tokens will eventually expire and require remaking. This is outside of Matillion's control. However, existing tokens may be extended or refreshed at any time.

While connector properties may differ between cloud data warehouses, the authentication process remains the same.


  • Begin the OAuth entry process as described in Manage OAuth. You should then configure this OAuth entry using the Facebook credentials, obtained as described below.
  • A new Facebook App should always be used when following this authentication process.
  • The callback URL, and therefore the Matillion ETL instance, must be HTTPS, not HTTP.

Acquiring third-party credentials

  1. Open the Facebook Developer Portal (also known as Meta for Developers).

  2. Click Log In on the top-right of the screen, and enter valid login credentials. Log In will be replaced on the menu by My Apps. Click My Apps to open your Apps page, which displays all your existing apps.

  3. Click Create App at the top-right of the Apps page.

  4. On the Select an app type screen, select the Business type, then click Next.

  5. On the Add details screen, provide details for the following fields, then click Create app:

  • Display name: Provide a name for the app, which will be used to identify it on the Apps page.
  • App Contact Email: Provide a contact email within your organization, to receive notifications and other communications regarding the app.
  • Business Account: From the drop-down list, select the business account that the app will be connected to. This is optional so it's normally fine to leave this field showing No Business Account selected, but certain app features will require the app to be connected to a business account.

Facebook will request you to re-enter your password as a security check before moving on to the next step.

  1. The browser will now show the Add Products to Your App screen. Locate the Facebook Login product, and click Set Up.

  2. Click Settings and then Basic on the sidebar. You will return to this screen later in the process, so you can ignore most of it now, but you must provide a Privacy Policy URL. This must be a valid link to your organization's online privacy policy. Enter the URL and click Save changes.

  3. Click Facebook Login and then Quickstart on the sidebar. The Quickstart wizard will open. Use this to add Facebook Login to your app. Begin by selecting a platform for the app.

  4. The wizard will reload with a block featuring a series of platform-specific questions and configurations. Follow the prompts and provide the required details. The details will vary depending on which platform you chose in the previous step. Click Next after completing each step of the wizard, until all steps are complete. For the purposes of the OAuth app, you will find that you can skip most of this information.

  5. Click Facebook Login and then Settings on the sidebar. This will open the Client OAuth settings screen. In the Valid OAuth Redirect URIs field, paste the Callback URL copied from the Manage OAuth dialog in Matillion ETL. Click Save changes.

  6. At the top of the Client OAuth Settings screen there is a red warning box informing you that your app currently has standard access to public_profile. In order to use Facebook Login, you'll need to gain advanced access to public profiling. To do this, click Get Advanced Access.

  7. On the Permissions and Features screen, scroll down to locate public_profile and click Get advanced access next to it.

  8. In the Confirm advanced access dialog, click to agree to the data usage policy and then click Confirm. Enter your account password when prompted and click Submit. After confirmation you'll be returned to the Permissions and Features dialog, where you'll be able to see your app's public profile setting, with the access level set to Advanced Access.

  9. Click Settings and then Advanced on the sidebar. Scroll down to the Domain Manager section of the page. Click Add a domain on the right of the screen to open the Add a domain dialog.

  10. In the Add a domain dialog, copy and paste the URL of Matillion ETL, and click the Exact Match option. Ensure that both the HTML and JavaScript and CSS options are selected. Then click Apply.

  11. Click Add Product next to Products in the sidebar to return to the Add products to your app screen. In the list of products available for your app, find Marketing API, and click Set Up. This will take you to the Welcome to Marketing API page, but no further configuration is required here.

  12. Click Settings and then Basic on the sidebar. Copy the credentials from both the App ID and App Secret fields. These will be required when configuring the OAuth in Matillion ETL in Matillion ETL.

  • To copy the App Secret, first click Show and enter your account password when prompted.
  • When copying the credentials, some browsers may add a space to the end of the string. Watch out for this as it will cause the credentials to fail.
  1. Now return to the Manage OAuth dialog in Matillion ETL to complete the OAuth configuration.