Sendgrid
Prerequisites
- API Key
Setting up the Sendgrid connector
| No | Item | Required | Example | Notes |
|---|---|---|---|---|
| 1 | Sendgrid API key | Yes | API Key, use admin to generate this key. | |
| 2 | Start time | No | 2020-01-01T01:01:01Z 2020-01-01T01:01:01.000001Z | Start time in ISO8601 format. Any data before this time point will not be replicated. |
Tables in the Sendgrid connector
| No | Table Name | Columns | Primary Keys | Read Mode | Inc. Sync Keys | API Info |
|---|---|---|---|---|---|---|
| 1 | blocks | 4 | Full Refresh, Incremental | created | API Reference | |
| 2 | templates | 5 | Full Refresh | API Reference | ||
| 3 | spam_reports | 3 | Full Refresh, Incremental | created | ||
| 4 | suppression_group_members | 4 | Full Refresh | |||
| 5 | stats_automations | 4 | Full Refresh | |||
| 6 | segments | 8 | Full Refresh | API Reference | ||
| 7 | global_suppressions | 2 | Full Refresh, Incremental | created | ||
| 8 | single_sends | 5 | Full Refresh | |||
| 9 | campaigns | 6 | Full Refresh | API Reference | ||
| 10 | suppression_groups | 5 | Full Refresh | |||
| 11 | lists | 4 | Full Refresh | API Reference | ||
| 12 | invalid_emails | 3 | Full Refresh, Incremental | created | ||
| 13 | bounces | 4 | Full Refresh, Incremental | created | API Reference | |
| 14 | contacts | 20 | Full Refresh | API Reference |
Table: blocks
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | reason | VARCHAR | |
| 2 | created | INTEGER | Incremental sync key |
| 3 | email | VARCHAR | |
| 4 | status | VARCHAR |
Table: templates
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | generation | VARCHAR | |
| 2 | updated_at | VARCHAR | |
| 3 | versions | VARCHAR | |
| 4 | name | VARCHAR | |
| 5 | id | VARCHAR |
Table: spam_reports
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | created | INTEGER | Incremental sync key |
| 2 | ip | VARCHAR | |
| 3 | email | VARCHAR |
Table: suppression_group_members
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | group_id | INTEGER | |
| 2 | group_name | VARCHAR | |
| 3 | created_at | INTEGER | |
| 4 | email | VARCHAR |
Table: stats_automations
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | stats | VARCHAR | |
| 2 | aggregation | VARCHAR | |
| 3 | id | VARCHAR | |
| 4 | step_id | VARCHAR |
Table: segments
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | next_sample_update | VARCHAR | |
| 2 | updated_at | VARCHAR | |
| 3 | contact_count | INTEGER | |
| 4 | name | VARCHAR | |
| 5 | created_at | VARCHAR | |
| 6 | id | VARCHAR | |
| 7 | sample_updated_at | VARCHAR | |
| 8 | parent_list_id | VARCHAR |
Table: global_suppressions
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | created | INTEGER | Incremental sync key |
| 2 | email | VARCHAR |
Table: single_sends
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | ab_phase | VARCHAR | |
| 2 | stats | VARCHAR | |
| 3 | aggregation | VARCHAR | |
| 4 | id | VARCHAR | |
| 5 | ab_variation | VARCHAR |
Table: campaigns
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | is_abtest | BOOLEAN | |
| 2 | updated_at | VARCHAR | |
| 3 | name | VARCHAR | |
| 4 | created_at | VARCHAR | |
| 5 | id | VARCHAR | |
| 6 | status | VARCHAR |
Table: suppression_groups
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | unsubscribes | INTEGER | |
| 2 | name | VARCHAR | |
| 3 | description | VARCHAR | |
| 4 | id | INTEGER | |
| 5 | is_default | BOOLEAN |
Table: lists
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | contact_count | INTEGER | |
| 2 | name | VARCHAR | |
| 3 | id | VARCHAR | |
| 4 | _metadata | VARCHAR |
Table: invalid_emails
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | reason | VARCHAR | |
| 2 | created | INTEGER | Incremental sync key |
| 3 | email | VARCHAR |
Table: bounces
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | reason | VARCHAR | |
| 2 | created | INTEGER | Incremental sync key |
| 3 | email | VARCHAR | |
| 4 | status | VARCHAR |
Table: contacts
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | whatsapp | VARCHAR | |
| 2 | country | VARCHAR | |
| 3 | city | VARCHAR | |
| 4 | state_province_region | VARCHAR | |
| 5 | custom_fields | VARCHAR | |
| 6 | line | VARCHAR | |
| 7 | facebook | VARCHAR | |
| 8 | last_name | VARCHAR | |
| 9 | created_at | VARCHAR | |
| 10 | contact_id | VARCHAR | |
| 11 | list_ids | VARCHAR | |
| 12 | unique_name | VARCHAR | |
| 13 | updated_at | VARCHAR | |
| 14 | alternate_emails | VARCHAR | |
| 15 | address_line_1 | VARCHAR | |
| 16 | phone_number | VARCHAR | |
| 17 | address_line_2 | VARCHAR | |
| 18 | postal_code | VARCHAR | |
| 19 | first_name | VARCHAR | |
| 20 | email | VARCHAR |
External Resources
- Create Sendgrid Api Key
- Stats Automations
- Single Sends
- Global Suppression
- Suppression Groups
- Suppression Group Members
- Invalid Emails
- Spam Reports
- Requests Limitation
Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.