Fivetran documentation

Search the docs

/

CircleCI

Explore the interactive ERD

Table & Field Reference

project

Column	Type	Keys
`id`	String	PK
`user_slug`	String	FK
`name`	String
`organization_id`	String
`organization_name`	String
`organization_slug`	String
`slug`	String
`vcs_info_default_branch`	String
`vcs_info_provider`	String
`vcs_info_vcs_url`	String

project_branch

Column	Type	Keys
`branch_name`	String	PK
`project_id`	String	PKFK

workflow_recent_run

Column	Type	Keys
`id`	String	PK
`project_id`	String	FK
`workflow_id`	String	FK
`branch`	String
`created_at`	Instant
`credits_used`	Double
`duration`	Double
`status`	String
`stopped_at`	Instant

user_collaboration

Column	Type	Keys
`slug`	String	PK
`avatar_url`	String
`id`	String
`name`	String
`vcs_type`	String

workflow_job_dependency

Column	Type	Keys
`dependency`	String	PK
`job_id`	String	PKFK

workflow_job

Column	Type	Keys
`id`	String	PK
`project_id`	String	FK
`workflow_id`	String	FK
`approval_request_id`	String
`approved_by`	String
`canceled_by`	String
`job_number`	String
`name`	String
`project_slug`	String
`started_at`	Instant
`status`	String
`stopped_at`	Instant
`type`	String

context

Column	Type	Keys
`id`	String	PK
`user_slug`	String	FK
`created_at`	Instant
`name`	String

flaky_test

Column	Type	Keys
`_fivetran_id`	String	PK
`project_id`	String	FK
`workflow_id`	Unknown	FK
`classname`	String
`file`	String
`job_name`	String
`job_number`	Double
`pipeline_number`	Double
`source`	String
`test_name`	String
`time_wasted`	Int
`times_flaked`	Int
`workflow_created_at`	Instant
`workflow_name`	String

pipeline_error

Column	Type	Keys
`_fivetran_id`	String	PK
`pipeline_id`	String	FK
`message`	String
`type`	String

pipeline

Column	Type	Keys
`id`	String	PK
`project_id`	String	FK
`created_at`	Instant
`number`	Double
`project_slug`	String
`state`	String
`trigger_actor_avatar_url`	String
`trigger_actor_login`	String
`trigger_received_at`	Instant
`trigger_type`	String
`updated_at`	Instant
`vcs_branch`	String
`vcs_commit_body`	String
`vcs_commit_subject`	String
`vcs_origin_repository_url`	String
`vcs_provider_name`	String
`vcs_review_id`	String
`vcs_review_url`	String
`vcs_revision`	String
`vcs_tags`	String
`vcs_target_repository_url`	String
`trigger_parameters_`

schedule_day_of_month

Column	Type	Keys
`date`	Int	PK
`schedule_id`	String	PKFK

schedule_month

Column	Type	Keys
`month`	String	PK
`schedule_id`	String	PKFK

schedule_hour_of_day

Column	Type	Keys
`hour`	Int	PK
`schedule_id`	String	PKFK

schedule_day_of_week

Column	Type	Keys
`day`	String	PK
`schedule_id`	String	PKFK

schedule

Column	Type	Keys
`id`	String	PK
`project_id`	String	FK
`actor_id`	String
`actor_login`	String
`actor_name`	String
`created_at`	Instant
`description`	String
`name`	String
`parameters_branch`	String
`parameters_deploy_prod`	Boolean
`project_slug`	String
`timetable_per_hour`	Int
`updated_at`	Instant

job_parallel_run

Column	Type	Keys
`_fivetran_id`	String	PK
`job_number`	String	FK
`project_id`	String	FK
`index`	Double
`status`	String

job_message

Column	Type	Keys
`_fivetran_id`	String	PK
`job_number`	String	FK
`project_id`	String	FK
`message`	String
`reason`	String
`type`	String

job_context

Column	Type	Keys
`name`	String	PK
`job_number`	String	FK
`project_id`	String	FK

job

Column	Type	Keys
`number`	String	PK
`project_id`	String	PKFK
`latest_workflow_name`	String	FK
`pipeline_id`	String	FK
`created_at`	Instant
`duration`	Double
`executor_resource_class`	String
`executor_type`	String
`name`	String
`organization_name`	String
`parallelism`	String
`queued_at`	Instant
`started_at`	Instant
`status`	String
`stopped_at`	Instant
`web_url`	String

job_artifact

Column	Type	Keys
`_fivetran_id`	String	PK
`job_number`	String	FK
`project_id`	String	FK
`node_index`	Double
`path`	String
`url`	String

workflow

Column	Type	Keys
`id`	String	PK
`pipeline_id`	String	FK
`project_id`	String	FK
`canceled_by`	String
`created_at`	Instant
`errored_by`	String
`name`	String
`project_slug`	String
`started_by`	String
`status`	String
`stopped_at`	Instant
`tags`	String