[SendGrid, SendGrid, is a customer communication platform for transactional and marketing emails., Features, Feature Name, Supported, Notes, Capture Deletes, check, Custom Data, check, EVENT, and , RECIPIENT, tables, Data Blocking, Column Hashing, Re-sync, check, Connector level, History, API Configurable, check, Priority-first sync, dbt Package, Setup guide, Follow our step-by-step , SendGrid setup guide, to connect SendGrid with your destination using Fivetran connectors., Sync overview, Fivetran uses a combination of SendGrid , REST APIs, and , Webhooks, to sync your data.nAt every update frequency, we retrieve , all, Campaigns, Senders, Lists, Recipients, Unsubscribe groups and their related entities. And for the Events, we retrieve only the , new, events that happened after the previous sync cycle., We support SendGrid accounts based on both , legacy marketing campaigns, and , new marketing campaigns, . We classify the connector based on the SendGrid account type you are using, and use custom sync strategies for each connector type:, Legacy: If you are using a legacy SendGrid account and have configured your connector with a legacy API key, we classify the connector as Legacy. We upsert the legacy tables in to the destination. See the , schema information, for details on the legacy tables. This schema applies to all legacy SendGrid connectors created before July 20, 2020., Upgraded: If you were using a legacy SendGrid account and had configured your connector with a legacy API key, but have migrated your account to a new marketing campaign account, and configured the existing connector with the new API key, we classify the connector as Upgraded. We upsert data from both new marketing tables and mapped legacy tables into the destination to support your existing queries on the legacy tables., New: If you have a new SendGrid account, and have created a new connector using a new API key, we classify the connector as New. We upsert the new marketing tables into the destination. See the , schema information, for details on the new marketing tables. This schema applies to all new SendGrid connectors created after July 20, 2020., See , New Marketing Campaigns, and our , detailed changelog, for more information., Schema information, New Marketing Campaigns, This schema is applicable for SendGrid connectors based on new marketing campaign accounts and applies to all connectors created after July 20, 2020., To zoom, open ERD in new window, Legacy Marketing Campaigns, This schema is applicable for SendGrid connectors based on legacy marketing campaign accounts and applies to all connectors created before July 20, 2020., To zoom, open ERD in new window, Events, SendGrid generates different kind of Events for your email Campaign. The different types of Events are listed , here, ., The following image shows where events can be generated while email is being processed:, NOTE: , The , Spam Report, event is not sent because SendGrid does not receive feedback from GMail., SendGrid does not support two or more Webhook URLs, so we cannot get , EVENT, data for a SendGrid account with two different Fivetran connectors. Due to this Webhooks limitation, you can only connect a SendGrid account to a single destination. , New Marketing Campaigns, SendGrid released a new set of API endpoints under , new marketing campaigns, on July 10, 2019. These new endpoints have been built on an entirely new platform, so they guarantee better performance and new features., Notes:, A new schema for new marketing campaigns is available., SendGrid‚Äôs existing set of , API endpoints, are now part of the , legacy marketing campaign APIs, ., “You cant access legacy marketing campaigns using a new marketing campaign account. You can only access the new API endpoints.”, “If you are using a SendGrid account based on legacy marketing campaigns, you will need to migrate your data into new marketing campaigns at some point in the future. The migration isnt automatic – you can either do the migration manually using SendGrid endpoints or you can contact the SendGrid‚Äôs support team for assistance. See “, “SendGrids migrating from legacy marketing campaigns documentation”, for more details. , “We will continue to support legacy SendGrid accounts along with the new ones. Existing customers can keep using their old accounts until SendGrid deprecates the legacy accounts. We have no information about SendGrids deprecation date for the legacy accounts.”, n]