Mailgun Connector Oveview

Mailgun is an email automation service provided by Rackspace. It offers a complete cloud-based email service for sending, receiving and tracking email sent through your websites and applications.

Features & Capabilities

  • Backfill: Full historical sync of your entire data
  • Data Extraction Modes: snapshot, incremental with pagination
  • Data Load Modes: replace, append and merge
  • Tables and Columns selection: Ability to select tables
  • Datalayout: changing the data type of your columns
  • Customizations: Update the configurations easily using the UI
  • Scheduling: Highly flexible scheduling system

Supported load units

The Mailgun connector automatically collects the following seven loadunits from the Mailgun API and makes them available in your warehouse for analysis.

LoadunitDefault modeAPI Endpoint
domainsSnapshothttps://api.mailgun.net/v3/domains
domain_eventsIncrementalupdatehttps://api.mailgun.net/v3/{domain}/events
domain_tagsSnapshothttps://api.mailgun.net/v3/{domain}/tags
domain_tags_statsIncrementalupdatehttps://api.mailgun.net/v3/{domain_name}/tags/{tag}/stats?event={event_type}
domain_ipsSnapshothttps://api.mailgun.net/v3/domains/{domain}/ips
domain_webhooksSnapshothttps://api.mailgun.net/v3/{domain}/webhooks
domain_whitelistsSnapshothttps://api.mailgun.net/v3/{domain}/whitelists
note
  • The resolution of stats data in domain_tag_stats loadunit is set hourly and we support daily syncs only
  • Pagination is supported for domains, domain_events, domain_tagsand domain_whitelists
  • Supported data format is JSON
  • API rate limits for the connector is 300 requests/min

Connector output

Output of this connector is stored in S3 and destination warehouse.

AWS S3 Data stored in AWS S3 is partitioned by date and time s3://customer_installation.datacoral/<connector-name>

Warehouse: Schema - schema name will be same as the connector name. Tables produced by the connector are:

- schema.domains
- schema.domain_events
- schema.domain_tags
- schema.domain_tags_stats
- schema.domain_ips
- schema.domain_webhooks
- schema.domain_whitelists

Next Steps

Additional Information

Got a question?

Please contact Datacoral's Support Team, we'd be more than happy to answer any of your questions.