Mandrill: структура данных в таблице BigQuery – Справочный центр OWOX

Название поля	Тип данных	Описание
_PARTITIONTIME	TIMESTAMP
ts	TIMESTAMP
event	STRING
_id	STRING
type	STRING
action	STRING
url	STRING
ip	STRING
user_agent	STRING
location	RECORD
location.country_short	STRING
location.country_long	STRING
location.region	STRING
location.city	STRING
location.postal_code	STRING
location.timezone	STRING
location.latitude	FLOAT
location.longitude	FLOAT
user_agent_parsed	RECORD
user_agent_parsed.mobile	BOOLEAN
user_agent_parsed.os_company	STRING
user_agent_parsed.os_company_url	STRING
user_agent_parsed.os_family	STRING
user_agent_parsed.os_icon	STRING
user_agent_parsed.os_name	STRING
user_agent_parsed.os_url	STRING
user_agent_parsed.type	STRING
user_agent_parsed.ua_company	STRING
user_agent_parsed.ua_company_url	STRING
user_agent_parsed.ua_family	STRING
user_agent_parsed.ua_icon	STRING
user_agent_parsed.ua_name	STRING
user_agent_parsed.ua_url	STRING
user_agent_parsed.ua_version	STRING
msg	RECORD
msg._id	STRING
msg.ts	TIMESTAMP
msg.email	STRING
msg.sender	STRING
msg.subject	STRING
msg.clicks	RECORD
msg.clicks.ts	TIMESTAMP
msg.clicks.url	STRING
msg.opens	RECORD
msg.opens.ip	STRING
msg.opens.location	STRING
msg.opens.ua	STRING
msg.smtp_events	RECORD
msg.smtp_events.ts	TIMESTAMP
msg.smtp_events.type	STRING
msg.smtp_events.destination_ip	STRING
msg.smtp_events.source_ip	STRING
msg.smtp_events.diag	STRING
msg.smtp_events.size	INTEGER
msg.tags	STRING
msg.metadata	RECORD
msg.metadata.key	STRING
msg.metadata.value	STRING
msg.state	STRING
msg.subaccount	STRING
msg.diag	STRING
msg.bounce_description	STRING
msg.template	STRING
entry	RECORD
entry.reason	STRING
entry.detail	STRING
entry.email	STRING
entry.last_event_at	STRING
entry.created_at	STRING
entry.expires_at	STRING
entry.expired	BOOLEAN
entry.subaccount	STRING
entry.sender	STRING
entry.sender_obj	RECORD
entry.sender_obj.sent	INTEGER
entry.sender_obj.hard_bounces	INTEGER
entry.sender_obj.soft_bounces	INTEGER
entry.sender_obj.rejects	INTEGER
entry.sender_obj.complaints	INTEGER
entry.sender_obj.soft_bounces	INTEGER
entry.sender_obj.rejects	INTEGER
entry.sender_obj.complaints	INTEGER
entry.sender_obj.unsubs	INTEGER
entry.sender_obj.opens	INTEGER
entry.sender_obj.clicks	INTEGER
entry.sender_obj.unique_opens	INTEGER
entry.sender_obj.unique_clicks	INTEGER
entry.sender_obj.reputation	INTEGER
entry.sender_obj.address	STRING
entry.sender_obj.created_at	STRING

0 Комментарии