Overview
The Lyftron Provider for Facebook offers the most natural way to access Facebook data from Lyftron with ease and also enables to connect with BI, MDM & ML tools, Data warehouses, Databases and other SAAS based applications with zero code and zero infrastructure requirements. The provider wraps the complexity of accessing Facebook data into easy-to-integrate relational fully managed ANSI Sql format. Make faster and better business decisions with Lyftron’s Facebook data provider and automatically build your data migration pipelines in minutes, not months
The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.
Key Features
- Comprehensive Delta load mechanism.
- Real-time access to Facebook.
- Comprehensive full support of ANSI Sql to query data with ease.
- Collaborative query processing.
Prerequisites
The user must have credentials for Facebook, Lyftron and your destination data warehouse, lake or database to perform the data pipeline operation with Lyftron
Establishing a Connection with Lyftron's Quickstart Steps
Create your Facebook connection with Lyftron by following the 5 easy steps show below:
Step1. Add your connection
Click on Connect section on the left panel → Click on Add Connection button
Step2. Select your connector
In the connector selection panel, search and click Facebook for your connection
Step3. Enter your connection details
Lyftron Data allows connectivity with three ways
- Lyftron Authentication : Embedded Oauth option where Lyftron data takes care of the connectivity and Oauth based on Lyftron Data Client Id and Lyftron Data Client Secret.
- Self Service Authentication: This is the regular Oauth option which requires Client Id and Client Secret for Oauth. This option requires Facebook App registration and more information can be found here
- Service Account Authentication: This is the manual connection string authentication. In the Connection String section enter the values of the below parameters. The following connection string is required to establish Facebook connection with Lyftron.
Key | Value | Field |
Connection Name | Enter your connection details | Required |
InitiateOAuth | your Facebook GETANDREFRESH | Required |
OAuthAccessToken | Your username | Required |
OAuthClientId | Your password | Required |
Logfile** | Use the logfile option to debug your job and provide your connection name to generate the log file. [ConnectionConfigurationPath]\Connection_name_log.tx | Optional |
Verbosity** | Choose verbosity 1-5 based on the severity of debugging | Optional |
** For more information, check the Lyftron logging and debugging section.
If you want more detailed information about how to establish a connection with Lyftron, click on Lyftron Connection Quick Start guide.
Step4. Test your connection
Once you are done entering your connection details, simply click on the Test Connection button to test the connectivity. In case your connection fails, add Logfile and Verbosity options and check the Lyftron logging and debugging section, to debug the error.
Step5. Save your connection
Hurray! Now you have successfully connected with the Lyftron Facebook connector and can utilize the connector to Extract, Warehouse, Analyze, Visualize and Share your data.
Data Model
The provider models the data in Facebook into a list of tables that can be queried using standard SQL statements.
Generally, querying Facebook tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns.
Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard. To find out more about tables and stored procedures, please navigate to their corresponding entries in this help document.
Name | Type | Description |
Likes | Tables | Create, delete, and query the Likes for a Target. Alternatively, lists Pages that the specified User or Page Likes. Authentication is required to use this table. |
Posts | Tables | Create, delete, and query the Posts for a Target based on either the Target or Id. Posts can also be inserted based on a Target, or deleted based on Id. This table requires authentication. |
AdAccounts | Views | Query the Ad Accounts available for a User. Accessing Ad Account information requires the ads_read permission. |
AdCreatives | Views | Query information about an Ad Creative or the Ad Creatives on a specific Ad Account, Ad Set, or Ad. Accessing Ad Creative information requires the ads_read permission. |
AdInsights | Views | Query an Ad Report. Accessing Ad Report information requires the ads_read permission. |
AdInsightsActions | Views | Query an Ad Report. Accessing Ad Report information requires the ads_read permission. |
AdLabels | Views | Query information about ad labels. Accessing Ad Information requires the ads_read permission. |
Ads | Views | Query information about an Ad or the Ads in a specific Ad Set, Campaign, or Ad Account. Accessing Ad Information requires the ads_read permission. |
AdScheduledReports | Views | Query the Scheduled Reports for a given Ad Account. Accessing Scheduled Report information requires the ads_read permission. |
AdSets | Views | Query information about an Ad Set or the Ad Sets on a specific Campaign or Ad Account. Accessing Ad Set information requires the ads_read permission. |
Albums | Views | Query Albums associated with a Target. Accessing Album information typically requires the user_photos permission. |
Applications | Views | Retrieve data about the Application specified by the Id. |
AuthorizedAdAccounts | Views | Ad Accounts authorized to run ads for your business on a specified app. This view requires that you have at least one business configured for your user id. |
Businesses | Views | Query the Businesses of a Facebook user. Accessing Business information requires the business_management permission. |
Campaigns | Views | Query information about a Campaign or the Campaigns on a specific Ad Account. Accessing Campaign information requires the ads_read permission. |
Comments | Views | Create, update, delete, and query the Comments for a Target. Comments may also be inserted based on a Target or deleted based on Id. |
ConversationMessages | Views | Query the Messages of a Conversation Target. |
Conversations | Views | Query the Conversations for a Target based on either the Target or Id. This view requires authentication. |
Events | Views | Query the Events for a Target based on either the Target. May require the user_events permission. |
Groups | Views | Query the Pages based on the supplied Id. |
InsightsByConsumptionType | Views | Allows retrieval of insights by consumption type. |
InsightsByFeedbackType | Views | Allows retrieval of insights by feedback type. |
InsightsByLikeSourceType | Views | Allows retrieval of insights by like source type. |
InsightsByReactionTotals | Views | Allows retrieval of insights by like source type. |
InsightsByStoryType | Views | Allows retrieval of insights by like story type. |
InsightsByTabType | Views | Allows retrieval of insights by tab type.. |
InsightsByUnLikeSourceType | Views | Allows retrieval of insights by like source type. |
InstagramAccountInsights | Views | Allows you to get insights for an Instagram Business Account. Requires the instagram_basic and instagram_manage_insights scopes. |
LeadValues | Views | Query information about a lead. Accessing Lead Information requires the ads_read permission. |
Movies | Views | Query the Movies a User is interested in. Accessing Movie information requires the user_likes and user_interests permissions. |
PageFansOnline | Views | Allows retrieval of page fans online - an hourly breakdown of when your fans saw any posts on Facebook on a given day. |
Pages | Views | Query the Pages based on the supplied Id. |
Permissions | Views | Query the Permissions the User has granted the current application. |
Photos | Views | Query Photos associated with a Target. Accessing Photo information typically requires the user_photos permission. |
Places | Views | Query the Places based on the supplied Id. Places are stored as Pages in Facebook. |
Ratings | Views | List of ratings for a Facebook Page. This view requires authentication. |
ScheduledReportRuns | Views | Query a list of the recently completed runs of a given Scheduled Report. Accessing Scheduled Report information requires the ads_read permission. |
SimpleInsights | Views | Allows the retrieval of simple insights with a single value in the response. |
SimpleVideoInsights | Views | Allows the retrieval of simple video insights with a single value in the response. |
TaggedBy | Views | Query information about Posts, Statuses, Photos, and other entities that have tagged the User or Page. This view is a derivative of the Wall connection where only entries that have tagged the Target User or Page will be returned. In general it is only available for Pages. |
Television | Views | Query the TV shows a User is interested in. Accessing Television information may require the user_likes and user_interested permissions. |
Users | Views | Returns basic information about the authenticated user. |
VideoInsightsByActionType | Views | Allows the retrieval of video insights by story action type. |
VideoInsightsByDistributionType | Views | Allows the retrieval of video insights by distribution type. |
VideoInsightsByReactionType | Views | Allows the retrieval of video insights by reaction type. |
Videos | Views | Query Videos from a Target. Normally requires the user_videos permission. |
Wall | Views | Query Posts from the Wall of a Target. |
Advanced Settings
To view a detailed advanced settings options, go to Facebook Advanced Settings. Complete list of the parameters you can configure in the connection string can be found by clicking Connection String Parameters.