How it works
ChartMogul writes each table to your bucket as a gzip-compressed CSV file or a Snappy-compressed Parquet file, whichever you choose.
Connecting. You give ChartMogul the bucket name, its region, and the access key of an IAM user that can write to it.
Setting it up
In ChartMogul, go to Settings > Destinations and add Amazon S3. The Amazon S3 guide walks through each step.
What ChartMogul exports
Every warehouse and storage destination gets the same two sets of tables.
Your source data
Customers, custom attributes, tags, contacts and their custom attributes, invoices and line items, transactions, subscription events, plans, opportunities and their custom attributes, notes and call logs, tasks, currency rates, and data sources.
ChartMogul’s calculations
Customers with their MRR, ARR, and status, subscriptions, MRR and CMRR movements, MRR per customer per month, MRR and quantity per customer per month per plan, MRR intervals, and plan groups.
When it runs
Daily, weekly, or monthly, and you can also send data on demand. Field-level schemas are in the developer docs.