Data Export to Majority

Data reaches Majority daily through an AWS S3 bucket.

AWS

• Role majority-s3-read-role, policy majority-s3-read-policy
• Bucket s3://rebtel-data-exports/majority/
• CSV, path <service_category>/<YYYY>/<MM>/<product>_transactions_<YYYY-MM-DD>.csv - <service_category>: mtu or calling - The date is the last completed day, so the export on 2025-01-20 holds 2025-01-19 - Example: s3://rebtel-data-exports/majority/mtu/2025/01/mtu_transactions_2025-01-19.csv
• If files get too big, split per day with copy into

Snowflake

• Export configuration
• Exported at 4 AM UTC daily, data available from 2025-01-16

Schema

Calling: CdrDetailId (Rebtel call ID), CallTime, AccessNumber, ANumber, BNumber, CallRatingUuid (Majority reference), Result, Duration (seconds)

MTU: OrderId, OrderCreatedAt, CustomerPriceAmount, CustomerPriceCurrency