Fivetran documentation

Search the docs

/

Split

Explore the interactive ERD

Table & Field Reference

groups

Column	Type	Keys
`id`	String	PK
`description`	String
`name`	String

environment

Column	Type	Keys
`id`	String	PK
`workspace_id`	String	FK
`name`	String
`production`	Boolean

change_request_comment

Column	Type	Keys
`_fivetran_id`	String	PK
`change_request_id`	String	FK
`comment`	String
`role`	String
`time_stamp`	Instant
`users`	String

change_request

Column	Type	Keys
`id`	String	PK
`rollout_status_id`	String	FK
`split_id`	Unknown	FK
`approvers`	Json
`operation_type`	String
`segment`	String
`split_open_change_request_id`	String
`split_split_id`	String
`status`	String
`title`	String

resource_permission_view

Column	Type	Keys
`user_id`	String	PKFK
`workspace_restriction_resource_id`	String	PKFK

workspace_restriction

Column	Type	Keys
`resource_id`	String	PKFK
`id`	String
`view`	Boolean

traffic_type

Column	Type	Keys
`id`	String	PK
`workspace_id`	String	FK
`display_attribute_id`	String
`name`	String

split_tag

Column	Type	Keys
`name`	String	PK
`split_id`	String	PKFK

split

Column	Type	Keys
`id`	String	PK
`rollout_status_id`	String	FK
`traffic_type_id`	String	FK
`workspace_id`	String	FK
`creation_time`	Instant
`description`	String
`name`	String
`rollout_status_timestamp`	String

rollout_status

Column	Type	Keys
`id`	String	PK
`workspace_id`	String	FK
`description`	String
`name`	String

split_definition_treatment

Column	Type	Keys
`_fivetran_id`	String	PK
`split_definition_environment_environment_id`	String	FK
`split_definition_environment_split_id`	String	FK
`configurations`	String
`description`	String
`key`	Json
`name`	String
`segment`	Json

split_definition_rule

Column	Type	Keys
`_fivetran_id`	String	PK
`split_definition_environment_environment_id`	String	FK
`split_definition_environment_split_id`	String	FK
`size`	Int
`treatment`	String

split_definition_rule_bucket

Column	Type	Keys
`index`	Unknown	PK
`environment_id`	String	PKFK
`split_id`	String	PKFK
`size`	Int
`treatment`	String

split_definition_rule_condition

Column	Type	Keys
`_fivetran_id`	String	PK
`split_definition_environment_environment_id`	String	FK
`split_definition_environment_split_id`	String	FK
`combiner`	String
`matchers`	Json

split_definition_environment

Column	Type	Keys
`environment_id`	String	PKFK
`split_id`	String	PKFK
`traffic_type_id`	String	FK
`workspace_id`	String	FK
`baseline_treatment`	String
`change_number`	Double
`creation_time`	Instant
`default_treatment`	String
`killed`	String
`last_update_time`	Instant
`traffic_allocation`	Int

workspace

Column	Type	Keys
`id`	String	PK
`name`	String
`requires_title_and_comments`	Boolean

attribute_suggested_value

Column	Type	Keys
`suggested_value`	String	PK
`attribute_id`	String	PKFK

attribute

Column	Type	Keys
`id`	String	PK
`traffic_type_id`	String	FK
`workspace_id`	String	FK
`data_type`	String
`display_name`	String
`is_searchable`	String
`organization_id`	String
`set_description`	String

segment_tag

Column	Type	Keys
`name`	String	PK
`segment_name`	String	PKFK

segment

Column	Type	Keys
`name`	String	PK
`workspace_id`	String	PKFK
`traffic_type_id`	String	FK
`creation_time`	Instant
`description`	String

segment_environment

Column	Type	Keys
`environment_id`	String	PKFK
`segment_name`	String	PKFK
`workspace_id`	String	PKFK
`traffic_type_id`	String	FK
`creation_time`	Instant

segment_key_environment

Column	Type	Keys
`_fivetran_id`	String	PK
`environment_id`	String	FK
`segment_environment_segment_name`	String	FK
`key`	String

user_group

Column	Type	Keys
`group_id`	String	PKFK
`users_id`	String	PKFK

users

Column	Type	Keys
`id`	String	PK
`email`	String
`name`	String
`status`	String
`two_factor_authentication`	Boolean
`type`	String