All customers can connect a data warehouse to Segment – Free and Team customers can connect one, while Business customers can connect as many as they need. We translate and load your raw data logs into your warehouse for more powerful analysis in SQL.

We store all your API calls as line-separated JSON objects in Amazon S3. If you enable Amazon S3 in your destinations catalog, we will copy the same data to your own S3 bucket. The data copied will only include data sent to Segment after you turn on the destination. Read our Amazon S3 docs to learn more about how we structure that data.

You can use our webhooks destination to fire off requests in realtime to an endpoint that you would need to spin up and manage on your side. This is basically re-creating how our business system works but takes a bit of work on your side. If your event volume is high it can be difficult to keep a server up to receive those messages in realtime.

Another one of our destinations is Iron.io. They function similar to webhooks, but they will manage the message queue and allow you to run scripts on your data before routing it to another end point. Again this is similar to what Segment does for our business customers, but will require a decent amount of work from your team, however it will be much more reliable if your event volume gets high.

This option is the most restrictive but might be the easiest if you need only basic data to be exported. A few examples would be to use the reporting APIs Clicky or Google Analytics provide (after turning those tools on in Segment and sending them data). Those APIs aren't super flexible and you won't see all the data from Segment, but for basic metrics they should work. One tool that's a bit more flexible when it comes to a reporting API is Keen.io, which is also available on the Segment platform.