Skip to main content
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:
TableDescription
CustomersCustomer records with metadata and custom fields
Products and PricesProduct catalog and pricing plans
SubscriptionsActive and historical subscription data
ContractsContract records with terms and status
Credits and DiscountsApplied credits and discount configurations
Invoices and Invoice Line ItemsInvoice records with detailed line items and status
PaymentsPayment 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