Fivetran documentation

Search the docs

/

Xray

Explore the interactive ERD

Table & Field Reference

status_detail

Column	Type	Keys
`_fivetran_id`	String	PK
`color`	Unknown
`description`	Unknown
`name`	Unknown
`object`	Unknown

test_step_attachment

Column	Type	Keys
`id`	Unknown	PK
`test_step_id`	Unknown	PKFK
`filename`	Unknown

test_step

Column	Type	Keys
`id`	Unknown	PK
`test_id`	Unknown	PKFK
`action`	Unknown
`data`	Unknown
`result`	Unknown
`custom_`

test

Column	Type	Keys
`id`	Unknown	PK
`assignee_account_id`	Unknown
`assignee_account_type`	Unknown
`assignee_active`	Unknown
`assignee_display_name`	Unknown
`assignee_pixel_16_16`	Unknown
`assignee_pixel_24_24`	Unknown
`assignee_pixel_32_32`	Unknown
`assignee_pixel_48_48`	Unknown
`assignee_self`	Unknown
`assignee_time_zone`	Unknown
`kind`	Unknown
`name`	Unknown
`reporter_account_id`	Unknown
`reporter_account_type`	Unknown
`reporter_active`	Unknown
`reporter_display_name`	Unknown
`reporter_pixel_16_16`	Unknown
`reporter_pixel_24_24`	Unknown
`reporter_pixel_32_32`	Unknown
`reporter_pixel_48_48`	Unknown
`reporter_self`	Unknown
`reporter_time_zone`	Unknown

pre_condition

Column	Type	Keys
`id`	Unknown	PK
`assignee_account_id`	Unknown	FK
`reporter_account_id`	Unknown	FK
`assignee_account_type`	Unknown
`assignee_active`	Unknown
`assignee_display_name`	Unknown
`assignee_pixel_16_16`	Unknown
`assignee_pixel_24_24`	Unknown
`assignee_pixel_32_32`	Unknown
`assignee_pixel_48_48`	Unknown
`assignee_self`	Unknown
`assignee_time_zone`	Unknown
`definition`	Unknown
`kind`	Unknown
`name`	Unknown
`reporter_account_type`	Unknown
`reporter_active`	Unknown
`reporter_display_name`	Unknown
`reporter_pixel_16_16`	Unknown
`reporter_pixel_24_24`	Unknown
`reporter_pixel_32_32`	Unknown
`reporter_pixel_48_48`	Unknown
`reporter_self`	Unknown
`reporter_time_zone`	Unknown

test_plan

Column	Type	Keys
`id`	Unknown	PK
`assignee_account_id`	Unknown	FK
`reporter_account_id`	Unknown	FK
`assignee_account_type`	Unknown
`assignee_active`	Unknown
`assignee_display_name`	Unknown
`assignee_pixel_16_16`	Unknown
`assignee_pixel_24_24`	Unknown
`assignee_pixel_32_32`	Unknown
`assignee_pixel_48_48`	Unknown
`assignee_self`	Unknown
`assignee_time_zone`	Unknown
`reporter_account_type`	Unknown
`reporter_active`	Unknown
`reporter_display_name`	Unknown
`reporter_pixel_16_16`	Unknown
`reporter_pixel_24_24`	Unknown
`reporter_pixel_32_32`	Unknown
`reporter_pixel_48_48`	Unknown
`reporter_self`	Unknown
`reporter_time_zone`	Unknown

test_execution

Column	Type	Keys
`id`	Unknown	PKFK
`assignee_account_id`	Unknown	FK
`reporter_account_id`	Unknown	FK
`assignee_account_type`	Unknown
`assignee_active`	Unknown
`assignee_display_name`	Unknown
`assignee_pixel_16_16`	Unknown
`assignee_pixel_24_24`	Unknown
`assignee_pixel_32_32`	Unknown
`assignee_pixel_48_48`	Unknown
`assignee_self`	Unknown
`assignee_time_zone`	Unknown
`reporter_account_type`	Unknown
`reporter_active`	Unknown
`reporter_display_name`	Unknown
`reporter_pixel_16_16`	Unknown
`reporter_pixel_24_24`	Unknown
`reporter_pixel_32_32`	Unknown
`reporter_pixel_48_48`	Unknown
`reporter_self`	Unknown
`reporter_time_zone`	Unknown

test_run

Column	Type	Keys
`id`	Unknown	PK
`execution_test_id`	Unknown	FK
`status_name`	Unknown	FK
`test_id`	Unknown	FK
`assignee_id`	Unknown
`examples`	Unknown
`executed_by_id`	Unknown
`finished_on`	Unknown
`gherkin`	Unknown
`last_modified`	Unknown
`started_on`	Unknown
`status_color`	Unknown
`status_description`	Unknown

expanded_test_attachment

Column	Type	Keys
`id`	Unknown	PK
`expanded_test_id`	Unknown	PKFK
`expanded_test_step_index`	Unknown	PKFK
`filename`	Unknown

expanded_test_step

Column	Type	Keys
`index`	Unknown	PK
`expanded_test_id`	Unknown	PKFK
`action`	Unknown
`called_test_issue_id`	Unknown
`data`	Unknown
`id`	Unknown
`parent_test_issue_id`	Unknown
`result`	Unknown
`custom_`

expanded_test

Column	Type	Keys
`id`	Unknown	PK
`assignee_account_id`	Unknown	FK
`reporter_account_id`	Unknown	FK
`assignee_account_type`	Unknown
`assignee_active`	Unknown
`assignee_display_name`	Unknown
`assignee_pixel_16_16`	Unknown
`assignee_pixel_24_24`	Unknown
`assignee_pixel_32_32`	Unknown
`assignee_pixel_48_48`	Unknown
`assignee_self`	Unknown
`assignee_time_zone`	Unknown
`kind`	Unknown
`name`	Unknown
`reporter_account_type`	Unknown
`reporter_active`	Unknown
`reporter_display_name`	Unknown
`reporter_pixel_16_16`	Unknown
`reporter_pixel_24_24`	Unknown
`reporter_pixel_32_32`	Unknown
`reporter_pixel_48_48`	Unknown
`reporter_self`	Unknown
`reporter_time_zone`	Unknown
`warnings`	Json

test_set

Column	Type	Keys
`id`	Unknown	PK
`assignee_account_id`	Unknown	FK
`reporter_account_id`	Unknown	FK
`assignee_account_type`	Unknown
`assignee_active`	Unknown
`assignee_display_name`	Unknown
`assignee_pixel_16_16`	Unknown
`assignee_pixel_24_24`	Unknown
`assignee_pixel_32_32`	Unknown
`assignee_pixel_48_48`	Unknown
`assignee_self`	Unknown
`assignee_time_zone`	Unknown
`reporter_account_type`	Unknown
`reporter_active`	Unknown
`reporter_display_name`	Unknown
`reporter_pixel_16_16`	Unknown
`reporter_pixel_24_24`	Unknown
`reporter_pixel_32_32`	Unknown
`reporter_pixel_48_48`	Unknown
`reporter_self`	Unknown
`reporter_time_zone`	Unknown