Table Selection for Facebook Ads and Salesforce

Flexibility is one of the primary reasons engineering teams choose to build their own data pipelines, rather than just buy a tool that does it for them. You want maximum control over the data being replicated into your warehouse. We get it; it’s your data.

That’s why, today we’re excited today to announce Table Selection for our Salesforce and Facebook Ads integrations. As of now, Stitch is the only self-serve data pipeline platform in the market that allows this type of flexibility. Now you can select the exact tables you want to sync to Amazon Redshift. No more unwanted data; no more running up against API limits.

Our approach

For Stitch, transparency and control are paramount. Over the last few weeks, our product team has received a ton of feedback from our customers around how best to continue to deliver on those fronts.

We consistently hear how beneficial it is that our database integrations provide the ability to select which fields and tables sync into your data warehouse. Today, we’re beginning to extend this same degree of control and flexibility to data being synced via our SaaS integrations.

Getting started

When you log in and click on your Salesforce or Facebook Ads integration, you’ll be prompted with a message about enabling table replication. After enabling, you’ll get to choose which tables you want sync into your data warehouse.

Salesforce table selection

Also, be sure to take advantage of our search bar at the top left of the UI. From here, you can can find and sync tables in a matter of seconds.

Find a table

If you’ve been meaning to connect a Salesforce or Facebook Ads integration to your Stitch account, there’s no better time than now. Connecting a SaaS app is almost as easy as logging into the service itself. In Stitch, click “Add an Integration,” then click the Salesforce icon, and then “Authenticate with Salesforce.” After you enter your credentials, allow Stitch to access your data. You’re all set!

For a list of the standard fields being replicated, check out our documentation for Salesforce and Facebook Ads.

On deck

We plan on deploying Table Selection to our Mixpanel and Netsuite integrations in a few days. And, as always, we would love to hear your feedback. If your team needs Table Selection for a SaaS integration not mentioned here, let us know.