> ## 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

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