Fivetran documentation

Search the docs

/

X Organic

Explore the interactive ERD

Table & Field Reference

tweet_user_mention

Column	Type	Keys
`id`	String	PK
`tweet_id`	String	PKFK
`indices`	Json
`name`	String
`screen_name`	String

tweet_hashtag

Column	Type	Keys
`index`	Long	PK
`tweet_id`	String	PKFK
`indices`	Json
`text`	String

account_history

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`approval_status`	String
`business_id`	String
`business_name`	String
`created_at`	Instant
`deleted`	Boolean
`industry_type`	String
`name`	String
`salt`	String
`timezone`	String
`timezone_switch_at`	Instant

tweet_symbols

Column	Type	Keys
`index`	Long	PK
`tweet_id`	String	PKFK
`indices`	Json
`text`	String

tweet

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`user_id`	Long	FK
`card_uri`	String
`coordinates_coordinates`	Json
`coordinates_type`	String
`created_at`	Instant
`favorite_count`	Long
`favorited`	Boolean
`followers`	Boolean
`full_text`	String
`geo_coordinates`	Json
`geo_type`	String
`in_reply_to_screen_name`	String
`in_reply_to_status_id`	String
`in_reply_to_user_id`	String
`lang`	String
`media_key`	String
`name`	String
`retweet_count`	Long
`retweeted`	Boolean
`source`	String
`truncated`	Boolean
`tweet_type`	String

card_component

Column	Type	Keys
`index`	Int	PK
`card_id`	String	PKFK
`label_type`	String
`label_value`	String
`media_key`	String
`title`	String
`type`	String
`destination_`

twitter_user_history

Column	Type	Keys
`id`	Long	PK
`contributors_enabled`	Boolean
`created_at`	Instant
`default_profile`	Boolean
`default_profile_image`	Boolean
`description`	String
`favourites_count`	Int
`followers_count`	Int
`following`	Boolean
`friends_count`	Int
`geo_enabled`	Boolean
`is_translation_enabled`	Boolean
`is_translator`	Boolean
`lang`	String
`listed_count`	Int
`location`	String
`name`	String
`profile_background_image_url`	String
`profile_background_image_url_https`	String
`profile_background_tile`	Boolean
`profile_banner_url`	String
`profile_image_url`	String
`profile_image_url_https`	String
`profile_use_background_image`	String
`protected_user`	Boolean
`screen_name`	String
`statuses_count`	Int
`time_zone`	String
`url`	String
`utc_offset`	Int
`verified`	Boolean

card_history

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`account_id`	String	FK
`app_cta`	String
`card_type`	String
`card_uri`	String
`content_duration_seconds`	Long
`country_code`	String
`created_at`	Instant
`deleted`	Boolean
`duration_in_minutes`	Long
`end_time`	Instant
`first_choice`	String
`first_cta`	String
`first_cta_tweet`	String
`first_cta_welcome_message_id`	String
`googleplay_app_id`	String
`image_display_height`	String
`image_display_width`	String
`media_key`	String
`media_url`	String
`name`	String
`poster_media_url`	String
`recipient_user_id`	String
`second_choice`	String
`start_time`	Instant
`thank_you_text`	String
`title`	String
`video_height`	String
`video_hls_url`	String
`video_owner_id`	String
`video_poster_height`	String
`video_poster_url`	String
`video_poster_width`	String
`video_url`	String
`video_width`	String
`website_dest_url`	String
`website_display_url`	String
`website_shortened_url`	String
`website_title`	String
`website_url`	String

media_library

Column	Type	Keys
`media_key`	String	PK
`created_at`	Instant
`deleted`	Boolean
`duration`	Long
`file_name`	String
`media_category`	String
`media_status`	String
`media_type`	String
`media_url`	String
`name`	String
`original_height`	Long
`original_width`	Long
`poster_media_key`	String
`poster_media_url`	String
`tweeted`	Boolean
`updated_at`	Instant

tweet_media

Column	Type	Keys
`media_id`	String	PK
`tweet_id`	String	PKFK
`display_url`	String
`expanded_url`	String
`indices`	Json
`media_key`	String
`media_url`	String
`media_url_https`	String
`sizes`	Json
`type`	String
`url`	String

scheduled_tweet_history

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`account_id`	String	FK
`tweet_id`	String	FK
`card_uri`	String
`completed_at`	Instant
`created_at`	Instant
`nullcast`	Boolean
`scheduled_at`	Instant
`scheduled_status`	String
`text`	String
`user_id`	String

tweet_url

Column	Type	Keys
`index`	Long	PK
`tweet_id`	String	PKFK
`display_url`	String
`expanded_url`	String
`indices`	Json
`url`	String