Fivetran documentation

Search the docs

/

Coalesce

Explore the interactive ERD

Table & Field Reference

source_node_hashed_column

Column	Type	Keys
`environment_id`	Unknown	PKFK
`id`	Unknown	PKFK
`source_node_id`	Unknown	PKFK

source_node_column

Column	Type	Keys
`id`	Unknown	PK
`environment_id`	Unknown	PKFK
`source_node_id`	Unknown	PKFK
`applied_column_tests`	Json
`column_references`	Json
`config`	Json
`data_type`	Unknown
`default_value`	Unknown
`description`	Unknown
`hash_algorithm`	Unknown
`hash_type`	Unknown
`hub_hashes`	Json
`is_business_key`	Unknown
`is_change_tracking`	Unknown
`is_surrogate_key`	Unknown
`key_column_type`	Unknown
`name`	Unknown
`nullable`	Unknown
`primary_key`	Unknown
`sources`	Json
`system_column_type`	Unknown
`transform`	Unknown
`unique_key`	Unknown

source_node

Column	Type	Keys
`id`	Unknown	PK
`environment_id`	Unknown	PKFK
`database`	Unknown
`description`	Unknown
`join_condition`	Unknown
`location_name`	Unknown
`name`	Unknown
`node_type`	Json
`schema`	Unknown
`source_mapping`	Json
`table_name`	Unknown

sql_node_hashed_column

Column	Type	Keys
`environment_id`	Unknown	PKFK
`id`	Unknown	PKFK
`sql_node_id`	Unknown	PKFK

sql_node_column

Column	Type	Keys
`id`	Unknown	PK
`environment_id`	Unknown	PKFK
`sql_node_id`	Unknown	PKFK
`applied_column_tests`	Json
`column_references`	Json
`config`	Json
`data_type`	Unknown
`default_value`	Unknown
`description`	Unknown
`hash_algorithm`	Unknown
`hash_type`	Unknown
`hub_hashes`	Json
`is_business_key`	Unknown
`is_change_tracking`	Unknown
`is_surrogate_key`	Unknown
`key_column_type`	Unknown
`name`	Unknown
`nullable`	Unknown
`primary_key`	Unknown
`sources`	Json
`system_column_type`	Unknown
`transform`	Unknown
`unique_key`	Unknown

sql_node_applied_test

Column	Type	Keys
`index`	Unknown	PK
`environment_id`	Unknown	PKFK
`sql_node_id`	Unknown	PKFK
`continue_on_failure`	Unknown
`description`	Unknown
`name`	Unknown
`run_order`	Unknown
`template_string`	Unknown

sql_node

Column	Type	Keys
`id`	Unknown	PK
`environment_id`	Unknown	PKFK
`config`	Json
`database`	Unknown
`description`	Unknown
`is_multisource`	Unknown
`join_condition`	Unknown
`location_name`	Unknown
`materialization_type`	Unknown
`metadata_cte_string`	Unknown
`metadata_description`	Unknown
`metadata_destination_name`	Unknown
`metadata_enabled_column_test_ids`	Json
`metadata_mapping`	Json
`metadata_materialization_option`	Unknown
`name`	Unknown
`node_type`	Json
`override_sql`	Unknown
`schema`	Unknown
`source_mapping`	Json
`table_name`	Unknown

environment

Column	Type	Keys
`id`	Unknown	PK
`connection_account`	Unknown
`created_at`	Unknown
`created_by_first_name`	Unknown
`created_by_id`	Unknown
`created_by_last_name`	Unknown
`current_git_branch`	Unknown
`current_git_commit`	Unknown
`current_mappings`	Json
`currently_running_jobs`	Json
`default_storage_mapping`	Unknown
`deployed_commit`	Unknown
`description`	Unknown
`name`	Unknown
`oauth_enabled`	Unknown
`project_id`	Unknown
`run_time_parameters`	Json
`status`	Unknown
`tag_background_color`	Unknown
`tag_text_color`	Unknown
`updated_at`	Unknown

run

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`run_environment_id`	Unknown	FK
`canceled`	Unknown
`deploy_commit`	Unknown
`deploy_commit_message`	Unknown
`end_time`	Unknown
`environment_id`	Unknown
`exclude_nodes_selector`	Unknown
`executor`	Unknown
`force_ignore_environment_status`	Unknown
`history`	Unknown
`include_nodes_selector`	Unknown
`job_id`	Unknown
`nodes_for_refresh`	Unknown
`nodes_in_run`	Unknown
`parallelism`	Unknown
`re_run_id`	Unknown
`refresh_description`	Unknown
`start_time`	Instant
`status`	Unknown
`time_parameters`	Json
`type`	Unknown
`user_credential_snowflake_account`	Unknown
`user_credential_snowflake_auth_type`	Unknown
`user_credential_snowflake_role`	Unknown
`user_credential_snowflake_username`	Unknown
`user_credential_snowflake_warehouse`	Unknown
`user_id`	Unknown
`version`	Unknown

run_query_result

Column	Type	Keys
`index`	Unknown	PK
`run_id`	Unknown	PKFK
`run_result_node_id`	Unknown	PKFK
`end_time`	Unknown
`error_detail`	Unknown
`error_string`	Unknown
`is_running`	Unknown
`name`	Unknown
`query_id`	Unknown
`row_deleted`	Unknown
`row_inserted`	Unknown
`row_updated`	Unknown
`sql`	Unknown
`start_time`	Unknown
`status`	Unknown
`success`	Unknown
`warehouse`	Unknown

run_result

Column	Type	Keys
`node_id`	Unknown	PK
`run_id`	Unknown	PKFK
`end_time`	Unknown
`error_detail`	Unknown
`error_string`	Unknown
`is_running`	Unknown
`name`	Unknown
`origin`	Unknown
`query_id`	Unknown
`row_deleted`	Unknown
`row_inserted`	Unknown
`row_updated`	Unknown
`run_state`	Unknown
`sql`	Unknown
`start_time`	Unknown
`status`	Unknown
`success`	Unknown
`warehouse`	Unknown