Sigma Computing
Explore the interactive ERD
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 | PKFK |
workbook_id | Unknown | PKFK |
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 | PKFK |
workbook_id | Unknown | PKFK |
filter_str | Unknown |
workbook_export_schedule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
workbook_id | Unknown | PKFK |
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 | PKFK |
workbook_query_id | Unknown | PKFK |
source | Unknown | FK |
target | Unknown | FK |
type | Unknown |
workbook_element_lineage_dependency
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
workbook_id | Unknown | PKFK |
workbook_query_id | Unknown | PKFK |
element_id | Unknown | FK |
name | Unknown | |
node_id | Unknown | |
type | Unknown |
workbook_version_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
workbook_version_version | Unknown | PKFK |
tagged_by | Unknown | FK |
version_tag_id | Unknown | FK |
tagged_at | Unknown |
workbook_version
| Column | Type | Keys |
|---|---|---|
version | Unknown | PK |
workbook_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
data_model_source_fivetran_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
team_id | Unknown | PKFK |
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 | PKFK |
workbook_source_fivetran_id | Unknown | PKFK |
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 | PKFK |
connection_path_id | Unknown | PKFK |
path_component | Unknown |
connection_path
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
connection_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
configured_at | Unknown | |
element_name | Unknown | |
paused | Unknown | |
schedule_cron_spec | Unknown | |
schedule_timezone | Unknown |