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