How to Load Facebook Insights to Your Data Warehouse in 90 Seconds

Speed and simplicity is at the heart of everything we do at Rivery.

With an increasing number of sources to analyze, we’re on a mission to help data teams streamline their operations and automate serverless data pipelines.

Loading data from a third party, such as Facebook or a Google Analytics data source, to your warehouse in the cloud used to be an annoying chore.

Now it can be automated. What’s more, using Rivery’s off the shelf data sources with the most popular 3rd party platforms means that your dev team won’t have to invest time developing a bespoke API.

The process is extremely simple, and here we’re breaking it down into 10 easy steps that will take you 90 seconds to complete.

Step 1: Go to Data Source to Target and name your new River

Step 2: Select the data source (i.e. Facebook Social) & connect with your credentials

Step 3: Select which of your pages you’d like the data for

Step 4: Choose the page attributes you’d like to bring into your data set

Step 5: Choose which type of data report you’d like to receive (i.e. page insights, post insights, etc.)

Step 6: Pick the metrics and time frame for your data

Step 7: Choose your target to define where the data will be shared to (i.e. Snowflake, AWS, Google, Azure).

Step 8: Define which database, schema, and table you want to load your data into – and choose a loading mode (append, upsert, overwrite).

Step 9: Column mapping. You can automate fields, without manually inputting them in your schema.

Rivery will detect the fields you selected in your source step.

Step 10: Run River! Click on ‘run’ and that’s it, your river will load the data into your table.

We hope you found this useful! Remember that these steps are very similar for integrations with other sources of data in addition to Facebook.

You can also watch the full 90 second video that takes you through all the steps here.