Hex

Explore the interactive ERD

Table & Field Reference

data_connection

Column	Type	Keys
`id`	Unknown	PK
`connection_details_bigquery_project_id`	Unknown	FK
`allow_writeback_cells`	Unknown
`connect_via_ssh`	Unknown
`connection_details_athena_access_key_id`	Unknown
`connection_details_athena_catalog`	Unknown
`connection_details_athena_hostname`	Unknown
`connection_details_athena_port`	Unknown
`connection_details_athena_s_3_output_path`	Unknown
`connection_details_athena_work_group`	Unknown
`connection_details_bigquery_enable_drive_access`	Unknown
`connection_details_bigquery_enable_storage_api`	Unknown
`connection_details_databricks_jdbc_url`	Unknown
`connection_details_postgres_database`	Unknown
`connection_details_postgres_host_name`	Unknown
`connection_details_postgres_port`	Unknown
`connection_details_postgres_username`	Unknown
`connection_details_redshift_database`	Unknown
`connection_details_redshift_host`	Unknown
`connection_details_redshift_port`	Unknown
`connection_details_redshift_username`	Unknown
`connection_details_snowflake_account_name`	Unknown
`connection_details_snowflake_database`	Unknown
`connection_details_snowflake_role`	Unknown
`connection_details_snowflake_schema`	Unknown
`connection_details_snowflake_username`	Unknown
`connection_details_snowflake_warehouse`	Unknown
`created_at`	Instant
`databases_exclude`	Json
`databases_include`	Json
`description`	Unknown
`include_magic`	Unknown
`name`	Unknown
`schema_refresh_access`	Unknown
`schema_refresh_schedule_cadence`	Unknown
`schema_refresh_schedule_custom_cron`	Unknown
`schema_refresh_schedule_custom_time_zone`	Unknown
`schema_refresh_schedule_daily_hour`	Unknown
`schema_refresh_schedule_daily_minute`	Unknown
`schema_refresh_schedule_daily_time_zone`	Unknown
`schema_refresh_schedule_enabled`	Unknown
`schema_refresh_schedule_monthly_day`	Unknown
`schema_refresh_schedule_monthly_hour`	Unknown
`schema_refresh_schedule_monthly_minute`	Unknown
`schema_refresh_schedule_monthly_time_zone`	Unknown
`schema_refresh_schedule_weekly_day_of_week`	Unknown
`schema_refresh_schedule_weekly_hour`	Unknown
`schema_refresh_schedule_weekly_minute`	Unknown
`schema_refresh_schedule_weekly_time_zone`	Unknown
`schemas_exclude`	Json
`schemas_include`	Json
`sharing_groups`	Json
`sharing_workspaces`	Json
`tables_exclude`	Json
`tables_include`	Json
`type`	Unknown

project_run_notification

Column	Type	Keys
`index`	Unknown	PK
`project_id`	Unknown	PKFK
`run_id`	Unknown	PKFK
`include_success_screenshot`	Unknown
`recipient_id`	Unknown
`recipient_is_private`	Unknown
`recipient_name`	Unknown
`recipient_type`	Unknown
`screenshot_format`	Json
`type`	Unknown

project_run

Column	Type	Keys
`run_id`	Unknown	PK
`project_id`	Unknown	PKFK
`elapsed_time`	Unknown
`end_time`	Unknown
`project_version`	Unknown
`run_url`	Unknown
`start_time`	Unknown
`status`	Unknown
`trace_id`	Unknown

project_queried_table

Column	Type	Keys
`table_name`	Unknown	PK
`data_connection_id`	Unknown	PKFK
`project_id`	Unknown	PKFK

project_category

Column	Type	Keys
`index`	Unknown	PK
`project_id`	Unknown	PKFK
`description`	Unknown
`name`	Unknown

project_schedule

Column	Type	Keys
`index`	Unknown	PK
`project_id`	Unknown	PKFK
`cadence`	Unknown
`custom_cron`	Unknown
`custom_timezone`	Unknown
`daily_hour`	Unknown
`daily_minute`	Unknown
`daily_timezone`	Unknown
`enabled`	Unknown
`hourly_minute`	Unknown
`hourly_timezone`	Unknown
`monthly_day`	Unknown
`monthly_hour`	Unknown
`monthly_minute`	Unknown
`monthly_timezone`	Unknown
`weekly_day_of_week`	Unknown
`weekly_hour`	Unknown
`weekly_minute`	Unknown
`weekly_timezone`	Unknown

project

Column	Type	Keys
`id`	Unknown	PK
`analytics_app_views_all_time`	Unknown
`analytics_app_views_last_fourteen_days`	Unknown
`analytics_app_views_last_seven_days`	Unknown
`analytics_app_views_last_thirty_days`	Unknown
`analytics_last_viewed_at`	Unknown
`analytics_published_result_updated_at`	Unknown
`archived_at`	Unknown
`created_at`	Unknown
`creator_email`	Unknown
`description`	Unknown
`last_edited_at`	Instant
`last_published_at`	Unknown
`owner_email`	Unknown
`review_required`	Unknown
`sharing_collections`	Json
`sharing_groups`	Json
`sharing_public_web_access`	Unknown
`sharing_support_access`	Unknown
`sharing_users`	Json
`sharing_workspace_access`	Unknown
`status`	Unknown
`title`	Unknown
`trashed_at`	Unknown
`type`	Unknown

groups

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`name`	Unknown

collection_sharing_group

Column	Type	Keys
`collection_id`	Unknown	PKFK
`id`	Unknown	PKFK
`access`	Unknown

collection_sharing_user

Column	Type	Keys
`collection_id`	Unknown	PKFK
`id`	Unknown	PKFK
`access`	Unknown

collection

Column	Type	Keys
`id`	Unknown	PK
`creator_id`	Unknown	FK
`description`	Unknown
`name`	Unknown
`sharing_workspace_member`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`email`	Unknown
`name`	Unknown
`role`	Unknown