Data Warehouses

We are excited to announce our new Amazon Redshift data warehouse integration for BigPicture.io!

You can now easily load customer data directly into your data warehouse without having to manage a data pipeline or write any code.

About Redshift

Redshift is a fast, fully managed data warehouse from Amazon that makes it simple to analyze all your data using standard SQL and your existing Business Intelligence (BI) tools.

It's been a popular tool for sales & marketing teams as it enables them to load all their customer data into one place and ask complex questions.

For example:

"How many customers that came in from the last Facebook campaign created a Zendesk ticket within the first week of signup?"

By loading data from all your different tools, you can now view and ask questions that span the entire customer journey.

Easier than building it yourself

If you've worked with Redshift, you may know that the hardest part is the data pipeline - getting your data into Redshift on an ongoing basis.

Without BigPicture.io

Here's what a typical data pipeline looks like without BigPicture.io.

  • API to receive data
  • Queue to collect and batch
  • Transform / normalize
  • Batch
  • Load

With BigPicture.io

Now here's what it looks like with BigPicture.io.

  • Connect in BigPicture.io

We make it possible to start using Redshift in minutes instead of months.

Features

Designed with simplicity in mind.

Faster sync times

Data is currently synced once an hour. Sync time can be customized if you need the data even quicker.

Built to scale

We worked closely with an enterprise customer to build this integration. It is designed for performance and to handle massive amounts of data.

Fully managed schema

We'll automatically add new tables, columns, and rows as you send us data.

Easy to migrate

Working with a 3rd party provider already? No problem. We've made it easy to migrate without any down time, and in some cases without having to change any code.

Secure

End to end encryption to secure your data.

Getting started

Getting started is simple.

Login to BigPicture.io and you'll now see Redshift available as an integration option. From there, just follow the directions and you can be up and running in minutes.

Questions? Shoot us an email at support@bigpicture.io

Michael Frye

Read more posts by this author.

Subscribe to The BigPicture.io Blog

Get the latest posts delivered right to your inbox.

or subscribe via RSS with Feedly!