Fivetran documentation

Search the docs

/

Mandrill

Explore the interactive ERD

Table & Field Reference

template_label

Column	Type	Keys
`label`	String	PK
`template_id`	String	PKFK

template

Column	Type	Keys
`id`	String	PK
`code`	String
`created_at`	LocalDateTime
`draft_updated_at`	LocalDateTime
`from_email`	String
`from_name`	String
`name`	String
`publish_code`	String
`publish_from_email`	String
`publish_from_name`	String
`publish_name`	String
`publish_subject`	String
`publish_text`	String
`published_at`	LocalDateTime
`subject`	String
`text`	String
`updated_at`	LocalDateTime

message_smtp_event

Column	Type	Keys
`index`	Int	PK
`message_event_fivetran_id`	Unknown	PKFK
`message_id`	String	PKFK
`destination_ip`	String
`diag`	String
`size`	Long
`source_ip`	String
`timestamps`	Instant
`type`	String

message_tag

Column	Type	Keys
`tags`	String	PK
`message_event_fivetran_id`	Unknown	PKFK
`message_id`	String	PKFK

message

Column	Type	Keys
`id`	String	PK
`event_fivetran_id`	Unknown	PKFK
`template_id`	String	FK
`bounce_description`	String
`diag`	String
`email`	String
`metadata`	Json
`sender`	String
`state`	String
`subaccount`	String
`subject`	String
`timestamps`	Instant

event

Column	Type	Keys
`_fivetran_id`	String	PK
`message_id`	String	FK
`event`	String
`ip`	String
`location_city`	String
`location_country_long`	String
`location_country_short`	String
`location_latitude`	String
`location_longitude`	String
`location_postal_code`	String
`location_region`	String
`location_timezone`	String
`timestamps`	Instant
`url`	String
`user_agent_company`	String
`user_agent_company_url`	String
`user_agent_family`	String
`user_agent_icon`	String
`user_agent_mobile`	Boolean
`user_agent_name`	String
`user_agent_os_company`	String
`user_agent_os_company_url`	String
`user_agent_os_family`	String
`user_agent_os_icon`	String
`user_agent_os_name`	String
`user_agent_os_url`	String
`user_agent_type`	String
`user_agent_url`	String
`user_agent_version`	String