# Hex schema ERD

Table and field reference for the Fivetran Hex connector.

## 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 | PK, FK |
| run_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| project_id | Unknown | PK, FK |

### project_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_id | Unknown | PK, FK |
| description | Unknown |  |
| name | Unknown |  |

### project_schedule

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_id | Unknown | PK, FK |
| 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 | PK, FK |
| id | Unknown | PK, FK |
| access | Unknown |  |

### collection_sharing_user

| Column | Type | Keys |
| --- | --- | --- |
| collection_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| 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 |  |

## Relationships

- data_connection(connection_details_bigquery_project_id) → project(id)
- project_run_notification(project_id) → project_run(project_id)
- project_run_notification(run_id) → project_run(run_id)
- project_run(project_id) → project(id)
- project_queried_table(data_connection_id) → data_connection(id)
- project_queried_table(project_id) → project(id)
- project_category(project_id) → project(id)
- project_schedule(project_id) → project(id)
- collection_sharing_group(id) → groups(id)
- collection_sharing_group(collection_id) → collection(id)
- collection_sharing_user(id) → users(id)
- collection_sharing_user(collection_id) → collection(id)
- collection(creator_id) → users(id)