SendGrid connector reference

Beta

This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Databricks previews.

This page has reference information for the managed SendGrid connector, including supported source tables and destination table schemas.

Supported source tables

The SendGrid connector supports the following source tables, all under the default source schema:

Source table	Primary key	Description	Sync mode	Cursor field
subusers	id	The subusers under the parent SendGrid account, including each subuser's username, email, and disabled state.	Full refresh only
recent_access_attempts	subuser, ip	Recent IP access attempts for each subuser, retrieved on behalf of the subuser.	Full refresh only
parent_access_attempts	ip	Recent IP access attempts for the parent account itself.	Full refresh only

Source table	Primary key	Description	Sync mode	Cursor field
subusers	id	The subusers under the parent SendGrid account, including each subuser's username, email, and disabled state.	Full refresh only
recent_access_attempts	subuser, ip	Recent IP access attempts for each subuser, retrieved on behalf of the subuser.	Full refresh only
parent_access_attempts	ip	Recent IP access attempts for the parent account itself.	Full refresh only

Connector options

The SendGrid connector has no additional configuration options beyond the pipeline settings available for all managed connectors. See Ingest data from SendGrid.

Destination table schemas

subusers

Primary key: id Sync mode: Full refresh only

Field	Data type
id	BIGINT
username	STRING
email	STRING
disabled	BOOLEAN

Field	Data type
id	BIGINT
username	STRING
email	STRING
disabled	BOOLEAN

recent_access_attempts

Primary key: subuser, ip Sync mode: Full refresh only

Field	Data type
subuser	STRING
allowed	BOOLEAN
auth_method	STRING
first_at	BIGINT
last_at	BIGINT
ip	STRING
location	STRING

Field	Data type
subuser	STRING
allowed	BOOLEAN
auth_method	STRING
first_at	BIGINT
last_at	BIGINT
ip	STRING
location	STRING

parent_access_attempts

Primary key: ip Sync mode: Full refresh only

Field	Data type
allowed	BOOLEAN
auth_method	STRING
first_at	BIGINT
last_at	BIGINT
ip	STRING
location	STRING

Field	Data type
allowed	BOOLEAN
auth_method	STRING
first_at	BIGINT
last_at	BIGINT
ip	STRING
location	STRING