Question

Is two-factor authentication (2FA) supported for the Facebook connector?

Environment

Connector: Facebook Ads

Answer

While Fivetran does not explicitly support two-factor authentication, we have seen that this still works when re-authorizing the connection in the Fivetran setup form and then completing the two-factor authentication through the Facebook app (you will still need to enter the code within the Facebook App). 

Since we will only be connecting to Facebook through one Facebook account, the API token should not expire as long as the connector is not paused for more than 2 months. It's not yet possible to determine the exact expiry time of the token for this type of authentication, but generally facebook token expires if no calls made through it in 60 days window, which we have seen to be consistent with our customers.