Fivetran documentation

Search the docs

/

Algolia

Explore the interactive ERD

Table & Field Reference

country

Column	Type	Keys
`country`	Unknown	PK
`index_name`	Unknown	PK
`start_date`	Unknown	PK
`count`	Unknown
`end_date`	Unknown

settings

Column	Type	Keys
`_fivetran_id`	String	PK
`index_name`	Unknown	FK
`alternatives_as_exact`	Unknown
`attribute_for_distinct`	Unknown
`attributes_for_faceting`	Unknown
`attributes_to_highlight`	Unknown
`attributes_to_index`	Unknown
`attributes_to_retrieve`	Unknown
`attributes_to_snippet`	Unknown
`exact_on_single_word_query`	Unknown
`highlight_post_tag`	Unknown
`highlight_pre_tag`	Unknown
`hits_per_page`	Unknown
`max_values_per_facet`	Unknown
`min_word_size_for_1_typo`	Unknown
`min_word_size_for_2_typo`	Unknown
`numeric_attributes_to_index`	Unknown
`optional_words`	Unknown
`pagination_limited_to`	Unknown
`query_type`	Unknown
`ranking`	Unknown
`remove_words_if_no_results`	Unknown
`separators_to_index`	Unknown
`snippet_ellipsis_text`	Unknown
`unretrievable_attributes`	Unknown
`version`	Unknown

click_through_rate

Column	Type	Keys
`date`	Unknown	PK
`index_name`	Unknown	PK
`click_count`	Unknown
`rate`	Unknown
`tracked_search_count`	Unknown

search_no_result_rate

Column	Type	Keys
`date`	Unknown	PK
`index_name`	Unknown	PK
`count`	Unknown
`no_result_count`	Unknown
`rate`	Unknown

average_click_position

Column	Type	Keys
`date`	Unknown	PK
`index_name`	Unknown	PK
`average`	Unknown
`click_count`	Unknown

click_position

Column	Type	Keys
`_fivetran_id`	String	PK
`click_count`	Unknown
`end_date`	Unknown
`index_name`	Unknown
`position`	Json
`start_date`	Unknown

index_detail

Column	Type	Keys
`id`	Unknown	PK
`index_name`	Unknown	FK

rule_condition

Column	Type	Keys
`index`	Unknown	PK
`rule_id`	Unknown	PKFK
`anchoring`	Unknown
`pattern`	Unknown

rule

Column	Type	Keys
`id`	Unknown	PK
`index_detail_id`	Unknown	FK
`index_name`	Unknown	FK

index_replica

Column	Type	Keys
`index`	Unknown	PK
`index_name`	Unknown	PKFK
`replica`	Unknown

index

Column	Type	Keys
`index_name`	Unknown	PK
`primary_index`	Unknown	FK
`created_at`	Unknown
`data_size`	Unknown
`entries`	Unknown
`file_size`	Unknown
`last_build_time_s`	Unknown
`number_of_pending_tasks`	Unknown
`pending_task`	Unknown
`updated_at`	Unknown
`virtual`	Unknown

top_filter

Column	Type	Keys
`_fivetran_id`	String	PK
`attribute`	Unknown
`count`	Unknown
`end_date`	Unknown
`index_name`	Unknown
`operator`	Unknown
`start_date`	Unknown
`value`	Unknown

search_no_click_rate

Column	Type	Keys
`date`	Unknown	PK
`index_name`	Unknown	PK
`count`	Unknown
`no_click_count`	Unknown
`rate`	Unknown

search_count

Column	Type	Keys
`_fivetran_id`	String	PK
`count`	Unknown
`date`	Unknown
`index_name`	Unknown

filter

Column	Type	Keys
`attribute`	Unknown	PK
`index_name`	Unknown	PK
`start_date`	Unknown	PK
`count`	Unknown
`end_date`	Unknown

hit

Column	Type	Keys
`_fivetran_id`	String	PK
`click_count`	Unknown
`conversion_count`	Unknown
`count`	Unknown
`end_date`	Unknown
`hit`	Unknown
`index_name`	Unknown
`start_date`	Unknown
`tracked_hit_count`	Unknown

search

Column	Type	Keys
`_fivetran_id`	String	PK
`click_count`	Unknown
`conversion_count`	Unknown
`count`	Unknown
`end_date`	Unknown
`index_name`	Unknown
`nb_hits`	Unknown
`search`	Unknown
`start_date`	Unknown
`tracked_search_count`	Unknown

user_count

Column	Type	Keys
`date`	Unknown	PK
`index_name`	Unknown	PK
`count`	Unknown

search_no_click

Column	Type	Keys
`_fivetran_id`	String	PK
`count`	Unknown
`end_date`	Unknown
`index_name`	Unknown
`nb_hits`	Unknown
`search`	Unknown
`start_date`	Unknown

search_no_result

Column	Type	Keys
`_fivetran_id`	String	PK
`count`	Unknown
`end_date`	Unknown
`index_name`	Unknown
`search`	Unknown
`start_date`	Unknown
`with_filter_count`	Unknown

conversion_rate

Column	Type	Keys
`date`	Unknown	PK
`index_name`	Unknown	PK
`conversion_count`	Unknown
`rate`	Unknown
`tracked_search_count`	Unknown