> ## Documentation Index
> Fetch the complete documentation index at: https://docs.getmeasure.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Amazon Redshift

<div style={{ display: 'flex', justifyContent: 'center' }}>
  <img src="https://mintcdn.com/stripedappsinc/F17N6K2YIOPBQ_jN/images/integrations/amazon-redshift.png?fit=max&auto=format&n=F17N6K2YIOPBQ_jN&q=85&s=5e9907f48253899080205393e3f76669" style={{ height: '200px', width: 'auto' }} width="800" height="448" data-path="images/integrations/amazon-redshift.png" />
</div>

Amazon Redshift integration enables you to export billing and subscription data to your Redshift data warehouse for advanced analytics, reporting, and integration with your broader data infrastructure.

## Key Capabilities

* **Automated sync**: Billing data automatically syncs to your Redshift cluster on a regular basis
* **Complete data export**: Export customers, subscriptions, invoices, payments, prices, credits, discounts and contracts
* **Schema management**: Measure manages table schemas and handles schema evolution as new fields are added
* **S3 staging support**: Optionally use an S3 bucket as a staging area for bulk loads to improve performance
* **SSH tunnel support**: Connect to Redshift clusters in private VPCs via an SSH tunnel

## Available Data

Export comprehensive billing data to Redshift:

| Table | Description |
| - | - |
| **Customers** | Customer records with metadata and custom fields |
| **Products and Prices** | Product catalog and pricing plans |
| **Subscriptions** | Active and historical subscription data |
| **Contracts** | Contract records with terms and status |
| **Credits and Discounts** | Applied credits and discount configurations |
| **Invoices and Invoice Line Items** | Invoice records with detailed line items and status |
| **Payments** | Payment transactions, refunds, failures, and retries |

Each dataset is modeled with stable primary keys and foreign-key relationships so you can confidently join across objects and time.

## Setup

To connect Redshift, you will need:

* **Host**: Your Redshift cluster endpoint
* **Port**: The port your cluster is listening on (default: 5439)
* **Database**: The target database name
* **Schema**: The schema where Measure will create tables
* **Username / Password**: Credentials with permission to create and write tables

### Optional: S3 Staging

For improved load performance, you can provide an S3 bucket for staging data before it is bulk-loaded into Redshift:

* **S3 Bucket Name** and **Region**
* **AWS Access Key ID** and **Secret Access Key**
* Optionally, an **S3 Bucket Path** prefix

### Optional: SSH Tunnel

If your Redshift cluster is in a private VPC, Measure can connect through an SSH bastion host:

* **SSH Host**, **Port**, and **Username**
* **SSH Private Key** (PEM format)

## Use Cases

* **Revenue analytics**: Build custom dashboards combining billing data with product and marketing data
* **Financial reporting**: Feed billing data into finance and FP\&A reporting tools
* **Customer health scoring**: Combine billing metrics with product usage for customer health analysis
* **Data warehousing**: Centralize billing data alongside other business data for unified analytics


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.