Warehouses

Your Segment warehouse lets you run SQL queries against your raw analytics data. You can use this to run hand-built queries, connect business intelligence tools, or refine data models that you can export to power recommendation engines and machine learning!

Warehouses is available for all customers. Getting your customer data into your Redshift, Postgres, or BigQuery data warehouse is now as easy as implementing Segment.

Setting Up

Segment can load data into three types of cloud data warehouses:

FAQs

How do I decide between Redshift, Postgres, and BigQuery?

What do you recommend for Postgres: Amazon or Heroku?

How do I give users permissions?

What are the limitations of Redshift clusters and our warehouses connector?

Where do I find my source slug?

Setting up a warehouse

What is a warehouse?

How do I create a user, grant usage on a schema and then grant the privileges that the user will need to interact with that schema?

Which IPs should I whitelist?

Will Segment sync my historical data?

Can I load in my own data into my warehouse?

Can I control what data is sent to my warehouse?

Managing a warehouse

How fresh is the data in my warehouse?

Can I add, tweak, or delete some of the tables?

Can I transform or clean up old data to new formats or specs?

What are common errors and how do I debug them?

How do I speed up my queries?

Analyzing with SQL

How do I forecast LTV with SQL and Excel for e-commerce businesses?

How do I measure the ROI of my Marketing Campaigns?

For additional information, check out our Guides section.

Request a Warehouse

What if I would like a warehouse that’s not currently on the platform? We’d love to know what you’d like. Please log your request.


If you have any questions or see anywhere we can improve our documentation, please let us know or kick off a conversation in the Segment Community!