# Sigma Computing schema ERD

Table and field reference for the Fivetran Sigma Computing connector.

## Table & Field Reference

### dataset_grant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| dataset_id | Unknown | FK |
| member_id | Unknown | FK |
| team_id | Unknown | FK |
| updated_by | Unknown | FK |
| created_at | Unknown |  |
| inode_id | Unknown |  |
| organization_id | Unknown |  |
| permission | Unknown |  |
| updated_at | Unknown |  |

### workspace

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### workbook_export_schedule_notification_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workbook_export_schedule_id | Unknown | PK, FK |
| workbook_id | Unknown | PK, FK |
| chart_id | Unknown |  |
| format_option_type | Unknown |  |
| workbook_export_source_element_id | Unknown |  |
| workbook_export_source_type | Unknown |  |

### workbook_export_schedule_dashboard_setting_filter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workbook_export_schedule_id | Unknown | PK, FK |
| workbook_id | Unknown | PK, FK |
| filter_str | Unknown |  |

### workbook_export_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workbook_id | Unknown | PK, FK |
| created_by | Unknown | FK |
| disabled_by | Unknown | FK |
| updated_by | Unknown | FK |
| alert_config_volume | Unknown |  |
| alert_config_window | Unknown |  |
| attachment_setting_merge_pdf_attachment | Unknown |  |
| attachment_setting_zip_attachments | Unknown |  |
| config_alert_pivot_header_style | Unknown |  |
| config_condition_option_type | Unknown |  |
| config_include_link | Unknown |  |
| config_message_body | Unknown |  |
| config_notification_name | Unknown |  |
| config_row_limit | Unknown |  |
| config_run_as_recipient | Unknown |  |
| config_title | Unknown |  |
| created_at | Unknown |  |
| dashboard_setting_variable_values_additional_prop_type | Unknown |  |
| dashboard_setting_variable_values_additional_prop_value | Unknown |  |
| disabled_at | Unknown |  |
| dynamic_export_settings_variable_additional_prop_type | Unknown |  |
| dynamic_recipient_setting_recipient_column_id | Unknown |  |
| dynamic_recipient_setting_source_node_id | Unknown |  |
| embed_opts_embed_id | Unknown |  |
| embed_opts_eval_connection_id | Unknown |  |
| is_suspended | Unknown |  |
| last_updated_by_user | Unknown |  |
| owner_id | Unknown |  |
| schedule_cron_spec | Unknown |  |
| schedule_timezone | Unknown |  |
| updated_at | Unknown |  |
| workbook_variant_bookmark_id | Unknown |  |
| workbook_variant_explore_key | Unknown |  |
| workbook_variant_tag_id | Unknown |  |

### user_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| created_at | Unknown |  |
| default_value | Unknown |  |
| default_value_type | Unknown |  |
| default_value_val | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### workbook_element_lineage_edge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workbook_id | Unknown | PK, FK |
| workbook_query_id | Unknown | PK, FK |
| source | Unknown | FK |
| target | Unknown | FK |
| type | Unknown |  |

### workbook_element_lineage_dependency

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| workbook_id | Unknown | PK, FK |
| workbook_query_id | Unknown | PK, FK |
| element_id | Unknown | FK |
| name | Unknown |  |
| node_id | Unknown |  |
| type | Unknown |  |

### workbook_version_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workbook_version_version | Unknown | PK, FK |
| tagged_by | Unknown | FK |
| version_tag_id | Unknown | FK |
| tagged_at | Unknown |  |

### workbook_version

| Column | Type | Keys |
| --- | --- | --- |
| version | Unknown | PK |
| workbook_id | Unknown | PK, FK |
| published_by | Unknown | FK |
| published_at | Unknown |  |

### dataset_materialization

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| dataset_id | Unknown | FK |
| code | Unknown |  |
| error_code | Unknown |  |
| error_message | Unknown |  |
| finished_at | Unknown |  |
| num_bytes | Unknown |  |
| num_rows | Unknown |  |
| runtime_secs | Unknown |  |
| status | Unknown |  |

### workbook_query

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workbook_id | Unknown | PK, FK |
| error | Unknown |  |
| name | Unknown |  |
| sql | Unknown |  |

### file

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| parent_id | Unknown | FK |
| updated_by | Unknown | FK |
| badge | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| is_archived | Unknown |  |
| name | Unknown |  |
| parent_url_id | Unknown |  |
| path | Unknown |  |
| permission | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| url_id | Unknown |  |

### data_model_source_element

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| data_model_source_data_model_id | Unknown | PK, FK |
| data_model_source_fivetran_id | Unknown | PK, FK |
| element_id | Unknown |  |

### data_model_source

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| data_model_id | Unknown | FK |
| version_tag_id | Unknown | FK |
| dataset_id | Unknown |  |
| table_id | Unknown |  |
| type | Unknown |  |

### member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| can_login | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| home_folder_id | Unknown |  |
| is_archived | Unknown |  |
| is_inactive | Unknown |  |
| last_name | Unknown |  |
| member_type | Unknown |  |
| organization_id | Unknown |  |
| profile_img_url | Unknown |  |
| updated_at | Unknown |  |
| user_kind | Unknown |  |

### member_grant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| member_id | Unknown | FK |
| team_id | Unknown | FK |
| updated_by | Unknown | FK |
| created_at | Unknown |  |
| inode_id | Unknown |  |
| inode_type | Unknown |  |
| organization_id | Unknown |  |
| permission | Unknown |  |
| updated_at | Unknown |  |

### connection_writeback

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| connection_id | Unknown | PK, FK |
| database | Unknown |  |
| schema | Unknown |  |

### connection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| account | Unknown |  |
| adhoc_pool_size | Unknown |  |
| catalog_pool_size | Unknown |  |
| created_at | Unknown |  |
| friendly_name | Unknown |  |
| host | Unknown |  |
| is_archived | Unknown |  |
| is_audit_log | Unknown |  |
| is_sample | Unknown |  |
| last_active_at | Unknown |  |
| materialization_warehouse | Unknown |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| result_pool_size | Unknown |  |
| role | Unknown |  |
| schedule_pool_size | Unknown |  |
| timeout_dashboard | Unknown |  |
| timeout_defaults | Unknown |  |
| timeout_download | Unknown |  |
| timeout_work_sheet | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| use_oauth | Unknown |  |
| users | Unknown |  |
| warehouse | Unknown |  |
| write_access | Unknown |  |

### workbook_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workbook_id | Unknown | PK, FK |
| version_tag_id | Unknown | FK |

### workbook

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| created_at | Unknown |  |
| is_archived | Unknown |  |
| latest_version | Unknown |  |
| name | Unknown |  |
| owner_id | Unknown |  |
| path | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| workbook_url_id | Unknown |  |

### data_model_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| data_model_id | Unknown | PK, FK |
| version_tag_id | Unknown | FK |
| source_version | Unknown |  |
| tag_name | Unknown |  |
| tagged_at | Unknown |  |

### data_model

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| created_at | Unknown |  |
| is_archived | Unknown |  |
| latest_version | Unknown |  |
| name | Unknown |  |
| owner_id | Unknown |  |
| path | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| url_id | Unknown |  |

### team_grant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| created_by | Unknown | FK |
| member_id | Unknown | FK |
| updated_by | Unknown | FK |
| created_at | Unknown |  |
| inode_id | Unknown |  |
| inode_type | Unknown |  |
| organization_id | Unknown |  |
| permission | Unknown |  |
| updated_at | Unknown |  |

### team_member

| Column | Type | Keys |
| --- | --- | --- |
| member_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| is_team_admin | Unknown |  |

### connection_grant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| connection_id | Unknown | FK |
| created_by | Unknown | FK |
| member_id | Unknown | FK |
| team_id | Unknown | FK |
| updated_by | Unknown | FK |
| created_at | Unknown |  |
| inode_id | Unknown |  |
| organization_id | Unknown |  |
| permission | Unknown |  |
| updated_at | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| is_archived | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |
| visibility | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| created_at | Unknown |  |
| is_archived | Unknown |  |
| name | Unknown |  |
| owner_id | Unknown |  |
| updated_at | Unknown |  |

### workbook_source_element

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workbook_id | Unknown | PK, FK |
| workbook_source_fivetran_id | Unknown | PK, FK |
| element_id | Unknown |  |

### workbook_source

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| data_model_id | Unknown | FK |
| version_tag_id | Unknown | FK |
| workbook_id | Unknown | FK |
| inode_id | Unknown |  |
| type | Unknown |  |

### connection_path_component

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| connection_path_connection_id | Unknown | PK, FK |
| connection_path_id | Unknown | PK, FK |
| path_component | Unknown |  |

### connection_path

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| connection_id | Unknown | PK, FK |

### dataset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| is_archived | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### favorite

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| member_id | Unknown | PK, FK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| badge | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| is_archived | Unknown |  |
| name | Unknown |  |
| owner_id | Unknown |  |
| parent_id | Unknown |  |
| parent_url_id | Unknown |  |
| path | Unknown |  |
| permission | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| url_id | Unknown |  |

### workbook_materialization_schedule

| Column | Type | Keys |
| --- | --- | --- |
| sheet_id | Unknown | PK |
| workbook_id | Unknown | PK, FK |
| configured_at | Unknown |  |
| element_name | Unknown |  |
| paused | Unknown |  |
| schedule_cron_spec | Unknown |  |
| schedule_timezone | Unknown |  |

## Relationships

- dataset_grant(team_id) → team(id)
- dataset_grant(created_by) → member(id)
- dataset_grant(member_id) → member(id)
- dataset_grant(updated_by) → member(id)
- dataset_grant(dataset_id) → dataset(id)
- workspace(created_by) → member(id)
- workspace(updated_by) → member(id)
- workbook_export_schedule_notification_attachment(workbook_export_schedule_id) → workbook_export_schedule(id)
- workbook_export_schedule_notification_attachment(workbook_id) → workbook_export_schedule(workbook_id)
- workbook_export_schedule_dashboard_setting_filter(workbook_export_schedule_id) → workbook_export_schedule(id)
- workbook_export_schedule_dashboard_setting_filter(workbook_id) → workbook_export_schedule(workbook_id)
- workbook_export_schedule(created_by) → member(id)
- workbook_export_schedule(updated_by) → member(id)
- workbook_export_schedule(disabled_by) → member(id)
- workbook_export_schedule(workbook_id) → workbook(id)
- user_attribute(created_by) → member(id)
- user_attribute(updated_by) → member(id)
- workbook_element_lineage_edge(source) → workbook_element_lineage_dependency(key)
- workbook_element_lineage_edge(target) → workbook_element_lineage_dependency(key)
- workbook_element_lineage_edge(workbook_id) → workbook_query(workbook_id)
- workbook_element_lineage_edge(workbook_query_id) → workbook_query(id)
- workbook_element_lineage_dependency(element_id) → workbook_query(id)
- workbook_element_lineage_dependency(workbook_id) → workbook_query(workbook_id)
- workbook_element_lineage_dependency(workbook_query_id) → workbook_query(id)
- workbook_version_tag(version_tag_id) → tags(id)
- workbook_version_tag(tagged_by) → member(id)
- workbook_version_tag(workbook_version_version) → workbook_version(version)
- workbook_version(published_by) → member(id)
- workbook_version(workbook_id) → workbook(id)
- dataset_materialization(dataset_id) → dataset(id)
- workbook_query(workbook_id) → workbook(id)
- file(created_by) → member(id)
- file(parent_id) → workspace(id)
- file(updated_by) → member(id)
- data_model_source_element(data_model_source_fivetran_id) → data_model_source(_fivetran_id)
- data_model_source_element(data_model_source_data_model_id) → data_model_source(data_model_id)
- data_model_source(version_tag_id) → tags(id)
- data_model_source(data_model_id) → data_model(id)
- member(created_by) → member(id)
- member(updated_by) → member(id)
- member_grant(team_id) → team(id)
- member_grant(created_by) → member(id)
- member_grant(member_id) → member(id)
- member_grant(updated_by) → member(id)
- connection_writeback(connection_id) → connection(id)
- connection(created_by) → member(id)
- connection(updated_by) → member(id)
- workbook_tag(version_tag_id) → tags(id)
- workbook_tag(workbook_id) → workbook(id)
- workbook(created_by) → member(id)
- workbook(updated_by) → member(id)
- data_model_tag(version_tag_id) → tags(id)
- data_model_tag(data_model_id) → data_model(id)
- data_model(created_by) → member(id)
- data_model(updated_by) → member(id)
- team_grant(team_id) → team(id)
- team_grant(created_by) → member(id)
- team_grant(member_id) → member(id)
- team_grant(updated_by) → member(id)
- team_member(member_id) → member(id)
- team_member(team_id) → team(id)
- connection_grant(team_id) → team(id)
- connection_grant(created_by) → member(id)
- connection_grant(member_id) → member(id)
- connection_grant(updated_by) → member(id)
- connection_grant(connection_id) → connection(id)
- team(created_by) → member(id)
- team(updated_by) → member(id)
- tags(created_by) → member(id)
- tags(updated_by) → member(id)
- workbook_source_element(workbook_source_fivetran_id) → workbook_source(_fivetran_id)
- workbook_source_element(workbook_id) → workbook_source(workbook_id)
- workbook_source(data_model_id) → data_model(id)
- workbook_source(version_tag_id) → tags(id)
- workbook_source(workbook_id) → workbook(id)
- connection_path_component(connection_path_id) → connection_path(id)
- connection_path_component(connection_path_connection_id) → connection_path(connection_id)
- connection_path(connection_id) → connection(id)
- dataset(created_by) → member(id)
- dataset(updated_by) → member(id)
- favorite(created_by) → member(id)
- favorite(updated_by) → member(id)
- favorite(member_id) → member(id)
- workbook_materialization_schedule(workbook_id) → workbook(id)