New Integration: Snowflake

Snowflake is a cloud-based data platform for storing, analyzing and securely sharing large volumes of data. With the new plugin, Maileon reporting data becomes a regular data source inside Snowflake and can be combined there with data from shops, CRM systems and other sources.

The plugin currently synchronizes:

• Event data: recipients, opens, clicks, bounces, blocks, subscriptions and unsubscriptions
• Campaign data: campaign metadata and aggregated campaign statistics
• Contact data: contact ID, email address, external ID, permission status and the associated timestamps
• Technical data: device, operating system, browser and rendering information, where available

The reporting database and the required tables are created and maintained in Snowflake by the plugin, so no manual schema setup is necessary. The connection uses key pair authentication with JWT and therefore works without a stored password. This makes campaign performance and recipient data available for central reporting, BI dashboards and advanced analytics or AI/ML use cases alongside the rest of the company data.