ETL SendGrid data to Snowflake

Enables sending transactional and marketing emails by specifying recipients, content, and email parameters. The endpoint accepts structured data including sender, recipients, subject, body, and optional attachments.

Manages recipient lists and contact details, allowing creation, retrieval, updating, and deletion of contact records. Data includes email addresses, custom fields, and list memberships.

Organizes contacts into logical groups for targeted email campaigns. Each list contains metadata and references to associated contacts.

Creates, schedules, and manages email marketing campaigns. Stores campaign metadata such as subject, content, recipient lists, and scheduling information.

Provides aggregated email performance metrics, including delivered, opens, clicks, bounces, and spam reports. Useful for monitoring and analyzing campaign effectiveness.

Manages suppression lists such as bounces, unsubscribes, and spam reports. Ensures compliance and prevents sending to recipients who should not receive emails.

Handles reusable email templates for consistent branding and content. Stores template structure, versions, and associated metadata.