Mode

Explore the interactive ERD

Table & Field Reference

report_collection_run

Column	Type	Keys
`id`	Unknown	PK
`report_collection_id`	Unknown	FK
`completed_at`	Unknown
`created_at`	Unknown
`form_fields`	Json
`is_latest_report_run`	Unknown
`is_latest_successful_report_run`	Unknown
`parameters`	Json
`purge_completed_at`	Unknown
`purge_started_at`	Unknown
`python_state`	Unknown
`report_has_failures_since_last_success`	Unknown
`state`	Unknown
`updated_at`	Unknown

collection

Column	Type	Keys
`id`	Unknown	PK
`default_access_level`	Unknown
`description`	Unknown
`free_default`	Unknown
`name`	Unknown
`restricted`	Unknown
`space_type`	Unknown
`state`	Unknown
`token`	Unknown
`viewable`	Unknown
`viewed`	Unknown

groups

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`managed`	Unknown
`name`	Unknown
`state`	Unknown
`type`	Unknown

data_source_custom_attribute

Column	Type	Keys
`name`	Unknown	PK
`data_source_id`	Unknown	PKFK
`value`	Unknown

data_source

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`adapter`	Unknown
`adapter_version`	Unknown
`asleep`	Unknown
`bridged`	Unknown
`created_at`	Unknown
`database`	Unknown
`default_access_level`	Unknown
`description`	Unknown
`display_name`	Unknown
`has_expensive_schema_updates`	Unknown
`host`	Unknown
`ldap`	Unknown
`name`	Unknown
`organization_plan_code`	Unknown
`organization_token`	Unknown
`port`	Unknown
`provider`	Unknown
`public`	Unknown
`queryable`	Unknown
`soft_deleted`	Unknown
`ssl`	Unknown
`ssl_trusted_cert`	Unknown
`token`	Unknown
`updated_at`	Unknown
`username`	Unknown
`vendor`	Unknown
`warehouse`	Unknown

dataset

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`data_source_id`	Unknown	FK
`archived`	Unknown
`color_mapping`	Unknown
`created_at`	Unknown
`description`	Unknown
`drill_anywhere_enabled`	Unknown
`drilldowns_enabled`	Unknown
`edited_at`	Unknown
`expected_runtime`	Unknown
`flamingo_signature`	Unknown
`full_width`	Unknown
`github_link`	Unknown
`imported_datasets`	Unknown
`is_embedded`	Unknown
`is_signed`	Unknown
`last_run_at`	Unknown
`last_saved_at`	Unknown
`last_successful_run_token`	Unknown
`last_successful_sync_at`	Unknown
`last_successfully_run_at`	Unknown
`layout`	Unknown
`manual_run_disabled`	Unknown
`name`	Unknown
`public`	Unknown
`published_at`	Unknown
`query_preview`	Unknown
`run_privately`	Unknown
`shared`	Unknown
`space_token`	Unknown
`theme_id`	Unknown
`token`	Unknown
`type`	Unknown
`updated_at`	Unknown
`view_count`	Unknown
`web_preview_image`	Unknown

report_data_source_schedule

Column	Type	Keys
`id`	Unknown	PK
`report_using_data_source_id`	Unknown	FK
`created_at`	Unknown
`hour`	Unknown
`last_run_at`	Unknown
`last_scheduled_run`	Unknown
`last_succeeded_at`	Unknown
`minute`	Unknown
`name`	Unknown
`next_scheduled_run`	Unknown
`parameters`	Json
`retry_state`	Unknown
`subscribed`	Unknown
`time_zone`	Unknown
`timeout`	Unknown
`type`	Unknown
`updated_at`	Unknown

report_collection_query

Column	Type	Keys
`id`	Unknown	PK
`data_source_id`	Unknown	FK
`report_collection_id`	Unknown	FK
`created_at`	Unknown
`dbt_metric_id`	Unknown
`dbt_metric_token`	Unknown
`explorations_count`	Unknown
`last_run_id`	Unknown
`mapping_id`	Unknown
`name`	Unknown
`raw_query`	Unknown
`token`	Unknown
`updated_at`	Unknown

collection_membership

Column	Type	Keys
`id`	Unknown	PK
`collection_id`	Unknown	PKFK
`email`	Unknown
`member_token`	Unknown
`token`	Unknown
`type`	Unknown

account_avatar

Column	Type	Keys
`name`	Unknown	PK
`account_id`	Unknown	PKFK
`value`	Unknown

account

Column	Type	Keys
`id`	Unknown	PK
`admin_data_source_connections_only`	Unknown
`authorized_domains`	Json
`created_at`	Unknown
`dataset_size_limit_mb`	Unknown
`is_user`	Unknown
`membership_type`	Unknown
`name`	Unknown
`payment_method_confirmed`	Unknown
`plan_code`	Unknown
`private_definition_limit`	Unknown
`query_run_size_limit_mb`	Unknown
`token`	Unknown
`trial_state`	Unknown
`username`	Unknown

report_collection_schedule

Column	Type	Keys
`id`	Unknown	PK
`report_collection_id`	Unknown	FK
`created_at`	Unknown
`hour`	Unknown
`last_run_at`	Unknown
`last_scheduled_run`	Unknown
`last_succeeded_at`	Unknown
`minute`	Unknown
`name`	Unknown
`next_scheduled_run`	Unknown
`parameters`	Json
`retry_state`	Unknown
`subscribed`	Unknown
`time_zone`	Unknown
`timeout`	Unknown
`type`	Unknown
`updated_at`	Unknown

dataset_schedule

Column	Type	Keys
`id`	Unknown	PK
`dataset_id`	Unknown	FK
`created_at`	Unknown
`hour`	Unknown
`last_run_at`	Unknown
`last_scheduled_run`	Unknown
`last_succeeded_at`	Unknown
`minute`	Unknown
`name`	Unknown
`next_scheduled_run`	Unknown
`parameters`	Json
`retry_state`	Unknown
`subscribed`	Unknown
`time_zone`	Unknown
`timeout`	Unknown
`type`	Unknown
`updated_at`	Unknown

report_using_data_source

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`data_source_id`	Unknown	FK
`account_username`	Unknown
`archived`	Unknown
`color_mapping`	Unknown
`created_at`	Unknown
`description`	Unknown
`drill_anywhere_enabled`	Unknown
`drilldowns_enabled`	Unknown
`edited_at`	Unknown
`expected_runtime`	Unknown
`full_width`	Unknown
`github_link`	Unknown
`imported_dataset`	Unknown
`is_embedded`	Unknown
`is_signed`	Unknown
`last_run_at`	Unknown
`last_saved_at`	Unknown
`last_successful_run_token`	Unknown
`last_successful_sync_at`	Unknown
`last_successfully_run_at`	Unknown
`layout`	Unknown
`manual_run_disabled`	Unknown
`name`	Unknown
`public`	Unknown
`published_at`	Unknown
`query_preview`	Unknown
`run_privately`	Unknown
`shared`	Unknown
`space_token`	Unknown
`theme_id`	Unknown
`token`	Unknown
`type`	Unknown
`updated_at`	Unknown
`view_count`	Unknown
`web_preview_image`	Unknown

definition

Column	Type	Keys
`id`	Unknown	PK
`data_source_id`	Unknown	FK
`created_at`	Unknown
`description`	Unknown
`github_link`	Unknown
`last_saved_at`	Unknown
`last_successful_sync_at`	Unknown
`name`	Unknown
`source`	Unknown
`token`	Unknown
`updated_at`	Unknown

report_collection_query_chart

Column	Type	Keys
`id`	Unknown	PK
`report_collection_id`	Unknown	FK
`report_collection_query_id`	Unknown	FK
`color_palette_token`	Unknown
`created_at`	Unknown
`switch_view_token`	Unknown
`updated_at`	Unknown
`view`	Json
`view_vegas`	Json
`view_version`	Unknown

report_data_source_query_run

Column	Type	Keys
`id`	Unknown	PK
`data_source_id`	Unknown	FK
`query_token`	Unknown	FK
`report_data_source_run_id`	Unknown	FK
`report_using_data_source_id`	Unknown	FK
`completed_at`	Unknown
`created_at`	Unknown
`dbt_metric_id`	Unknown
`dbt_metric_token`	Unknown
`error_code`	Unknown
`error_message`	Unknown
`error_type`	Unknown
`help_url`	Unknown
`limits`	Unknown
`max_result_bytes`	Unknown
`parameters`	Json
`raw_source`	Unknown
`rendered_source`	Unknown
`state`	Unknown
`statement_annotation`	Unknown
`token`	Unknown

report_data_source_query

Column	Type	Keys
`id`	Unknown	PK
`data_source_id`	Unknown	FK
`report_using_data_source_id`	Unknown	FK
`created_at`	Unknown
`dbt_metric_id`	Unknown
`dbt_metric_token`	Unknown
`explorations_count`	Unknown
`last_run_id`	Unknown
`mapping_id`	Unknown
`name`	Unknown
`raw_query`	Unknown
`token`	Unknown
`updated_at`	Unknown

report_data_source_run

Column	Type	Keys
`id`	Unknown	PK
`report_using_data_source_id`	Unknown	FK
`completed_at`	Unknown
`created_at`	Unknown
`form_fields`	Json
`is_latest_report_run`	Unknown
`is_latest_successful_report_run`	Unknown
`parameters`	Json
`purge_completed_at`	Unknown
`purge_started_at`	Unknown
`python_state`	Unknown
`report_has_failures_since_last_success`	Unknown
`state`	Unknown
`updated_at`	Unknown

group_membership

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`member_id`	Unknown	FK

workspace_membership

Column	Type	Keys
`id`	Unknown	PK
`activated_at`	Unknown
`admin`	Unknown
`invited`	Unknown
`managed_by_scim`	Unknown
`state`	Unknown
`username`	Unknown

dataset_run

Column	Type	Keys
`id`	Unknown	PK
`dataset_id`	Unknown	FK
`created_at`	Unknown
`form_fields`	Json
`is_latest_report_run`	Unknown
`is_latest_successful_report_run`	Unknown
`parameters`	Json
`purge_completed_at`	Unknown
`purge_started_at`	Unknown
`python_state`	Unknown
`report_has_failures_since_last_success`	Unknown
`state`	Unknown
`updated_at`	Unknown

report_data_source_query_chart

Column	Type	Keys
`id`	Unknown	PK
`report_data_source_query_id`	Unknown	FK
`report_using_data_source_id`	Unknown	FK
`color_palette_token`	Unknown
`created_at`	Unknown
`switch_view_token`	Unknown
`updated_at`	Unknown
`view`	Json
`view_vegas`	Json
`view_version`	Unknown

report_collection_query_run

Column	Type	Keys
`id`	Unknown	PK
`data_source_id`	Unknown	FK
`query_token`	Unknown	FK
`report_collection_id`	Unknown	FK
`report_collection_run_id`	Unknown	FK
`completed_at`	Unknown
`created_at`	Unknown
`dbt_metric_id`	Unknown
`dbt_metric_token`	Unknown
`error_code`	Unknown
`error_message`	Unknown
`error_type`	Unknown
`help_url`	Unknown
`limits`	Unknown
`max_result_bytes`	Unknown
`parameters`	Json
`raw_source`	Unknown
`rendered_source`	Unknown
`state`	Unknown
`statement_annotation`	Unknown
`token`	Unknown

report_collection

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`collection_id`	Unknown	FK
`account_username`	Unknown
`archived`	Unknown
`color_mapping`	Unknown
`created_at`	Unknown
`description`	Unknown
`drill_anywhere_enabled`	Unknown
`drilldowns_enabled`	Unknown
`edited_at`	Unknown
`expected_runtime`	Unknown
`full_width`	Unknown
`github_link`	Unknown
`imported_dataset`	Unknown
`is_embedded`	Unknown
`is_signed`	Unknown
`last_run_at`	Unknown
`last_saved_at`	Unknown
`last_successful_run_token`	Unknown
`last_successful_sync_at`	Unknown
`last_successfully_run_at`	Unknown
`layout`	Unknown
`manual_run_disabled`	Unknown
`name`	Unknown
`public`	Unknown
`published_at`	Unknown
`query_preview`	Unknown
`run_privately`	Unknown
`shared`	Unknown
`space_token`	Unknown
`theme_id`	Unknown
`token`	Unknown
`type`	Unknown
`updated_at`	Unknown
`view_count`	Unknown
`web_preview_image`	Unknown