# dbt platform schema ERD

Table and field reference for the Fivetran dbt platform connector.

## Table & Field Reference

### audit_log_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| actor | Unknown |  |
| created_at | Unknown |  |
| event_context | Unknown |  |
| event_label | Unknown |  |
| event_type | Unknown |  |
| service | Unknown |  |
| source | Unknown |  |

### oauth_configuration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| application_id_uri | Unknown |  |
| authorize_url | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| redirect_uri | Unknown |  |
| token_url | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| connection_id | Unknown | FK |
| docs_job_id | Unknown | FK |
| freshness_job_id | Unknown | FK |
| repository_id | Unknown | FK |
| created_at | Unknown |  |
| dbt_project_subdirectory | Unknown |  |
| group_permissions | Json |  |
| name | Unknown |  |
| semantic_layer_config_id | Unknown |  |
| skipped_setup | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |

### run_step

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| run_id | Unknown | FK |
| created_at | Unknown |  |
| debug_log | Unknown |  |
| debug_log_path | Unknown |  |
| duration | Unknown |  |
| duration_humanized | Unknown |  |
| finished_at | Unknown |  |
| index | Unknown |  |
| log_archive_type | Unknown |  |
| log_location | Unknown |  |
| log_path | Unknown |  |
| name | Unknown |  |
| run_step_command | Unknown |  |
| started_at | Unknown |  |
| status | Unknown |  |
| status_color | Unknown |  |
| status_humanized | Unknown |  |
| updated_at | Unknown |  |

### run_trigger

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| run_id | Unknown | FK |
| azure_pull_request_id | Unknown |  |
| cause_category | Unknown |  |
| cause_humanized | Unknown |  |
| created_at | Unknown |  |
| dbt_version_override | Unknown |  |
| generate_docs_override | Unknown |  |
| git_branch | Unknown |  |
| git_sha | Unknown |  |
| github_pull_request_id | Unknown |  |
| gitlab_merge_request_id | Unknown |  |
| job | Unknown |  |
| job_definition_id | Unknown |  |
| non_native_pull_request_id | Unknown |  |
| schema_override | Unknown |  |
| steps_override | Unknown |  |
| target_name_override | Unknown |  |
| threads_override | Unknown |  |
| timeout_seconds_override | Unknown |  |

### run

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| environment_id | Unknown | FK |
| job_id | Unknown | FK |
| project_id | Unknown | FK |
| artifact_s_3_path | Unknown |  |
| artifacts_saved | Unknown |  |
| blocked_by | Json |  |
| created_at | Unknown |  |
| created_at_humanized | Unknown |  |
| dbt_version | Unknown |  |
| deferring_run_id | Unknown |  |
| dequeued_at | Unknown |  |
| duration | Unknown |  |
| duration_humanized | Unknown |  |
| executed_by_thread_id | Unknown |  |
| finished_at | Unknown |  |
| finished_at_humanized | Unknown |  |
| git_branch | Unknown |  |
| git_sha | Unknown |  |
| has_docs_generated | Unknown |  |
| has_sources_generated | Unknown |  |
| href | Unknown |  |
| in_progress | Unknown |  |
| is_cancelled | Unknown |  |
| is_complete | Unknown |  |
| is_error | Unknown |  |
| is_running | Unknown |  |
| is_success | Unknown |  |
| last_checked_at | Unknown |  |
| last_heartbeat_at | Unknown |  |
| notifications_sent | Unknown |  |
| owner_thread_id | Unknown |  |
| queued_duration | Unknown |  |
| queued_duration_humanized | Unknown |  |
| run_duration | Unknown |  |
| run_duration_humanized | Unknown |  |
| scribe_enabled | Unknown |  |
| should_start_at | Unknown |  |
| started_at | Unknown |  |
| status | Unknown |  |
| status_humanized | Unknown |  |
| status_message | Unknown |  |
| trigger_id | Unknown |  |
| updated_at | Unknown |  |

### repository

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| project_id | Unknown | FK |
| created_at | Unknown |  |
| deploy_key_id | Unknown |  |
| deploy_key_state | Unknown |  |
| full_name | Unknown |  |
| git_clone_strategy | Unknown |  |
| git_provider_id | Unknown |  |
| git_provider_state | Unknown |  |
| github_installation_id | Unknown |  |
| github_repo | Unknown |  |
| github_webhook_id | Unknown |  |
| gitlab_id | Unknown |  |
| gitlab_project_access_token_id | Unknown |  |
| gitlab_state | Unknown |  |
| name | Unknown |  |
| private_link_endpoint_id | Unknown |  |
| pull_request_url_template | Unknown |  |
| remote_backend | Unknown |  |
| remote_url | Unknown |  |
| repository_credentials_id | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |

### notification_on_failure

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| notification_id | Unknown | PK, FK |
| on_failure | Unknown |  |

### notification_on_cancel

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| notification_id | Unknown | PK, FK |
| on_cancel | Unknown |  |

### notification_on_success

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| notification_id | Unknown | PK, FK |
| on_success | Unknown |  |

### notification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| external_email | Unknown |  |
| slack_channel_id | Unknown |  |
| slack_channel_name | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### connection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| adapter_version | Unknown |  |
| config_account | Unknown |  |
| config_allow_sso | Unknown |  |
| config_client_session_keep_alive | Unknown |  |
| config_database | Unknown |  |
| config_role | Unknown |  |
| config_warehouse | Unknown |  |
| created_at | Unknown |  |
| is_ssh_tunnel_enabled | Unknown |  |
| name | Unknown |  |
| oauth_configuration_id | Unknown |  |
| platform_metadata_credentials_id | Unknown |  |
| private_link_endpoint_id | Unknown |  |
| updated_at | Unknown |  |

### webhook_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| job_id | Unknown | FK |
| description | Unknown |  |
| http_status_code | Unknown |  |
| name | Unknown |  |
| payload | Unknown |  |
| subscription_id | Unknown |  |
| trigger_event_type | Unknown |  |

### ip_restriction_cidr

| Column | Type | Keys |
| --- | --- | --- |
| ip_restriction_rule_id | Unknown | PK |
| ip_restriction_id | Unknown | PK, FK |
| cidr | Unknown |  |
| cidr_ipv_6 | Unknown |  |
| enabled | Unknown |  |
| state | Unknown |  |

### ip_restriction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| created_at | Unknown |  |
| created_by_id | Unknown |  |
| created_by_service_token_id | Unknown |  |
| description | Unknown |  |
| enabled_for_service_tokens | Unknown |  |
| ip_restriction_rule_set_id | Unknown |  |
| name | Unknown |  |
| rule_set_enabled | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### run_artifact

| Column | Type | Keys |
| --- | --- | --- |
| run_artifact_id | Unknown | PK |
| account_id | Unknown | PK, FK |
| run_id | Unknown | PK, FK |

### run_result_timing

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| run_id | Unknown | PK, FK |
| run_result_unique_id | Unknown | PK, FK |
| completed_at | Unknown |  |
| name | Unknown |  |
| started_at | Unknown |  |

### run_result

| Column | Type | Keys |
| --- | --- | --- |
| unique_id | Unknown | PK |
| account_id | Unknown | PK, FK |
| run_id | Unknown | PK, FK |
| adapter_response_code | Unknown |  |
| adapter_response_message | Unknown |  |
| adapter_response_query_id | Unknown |  |
| adapter_response_rows_affected | Unknown |  |
| batch_results | Json |  |
| compiled | Unknown |  |
| compiled_code | Unknown |  |
| execution_time | Unknown |  |
| failures | Unknown |  |
| message | Unknown |  |
| relation_name | Unknown |  |
| status | Unknown |  |
| thread_id | Unknown |  |

### auth_provider_user_groups

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| users_id | Unknown | FK |
| group_name | Unknown |  |

### group_permission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| group_id | Unknown | FK |
| project_id | Unknown | FK |
| all_projects | Unknown |  |
| created_at | Unknown |  |
| permission_level | Unknown |  |
| permission_set | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| permission_id | Unknown | PK, FK |
| account_id | Unknown | FK |
| assign_by_default | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| sso_mapping_group | Json |  |
| state | Unknown |  |
| updated_at | Unknown |  |

### permission_statement

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| permission_id | Unknown | FK |
| all_resources | Unknown |  |
| permission | Unknown |  |
| target_resource | Unknown |  |

### permission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| license_type | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| auth_provider_infos_qw_corp_auth_provider_type | Unknown |  |
| auth_provider_infos_qw_corp_domain | Unknown |  |
| avatar_url | Unknown |  |
| azure_active_directory_connected | Unknown |  |
| azure_active_directory_username | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| email_connected | Unknown |  |
| email_verified | Unknown |  |
| enterprise_authentication_method | Unknown |  |
| enterprise_connected | Unknown |  |
| first_name | Unknown |  |
| fullname | Unknown |  |
| github_connected | Unknown |  |
| github_username | Unknown |  |
| gitlab_connected | Unknown |  |
| gitlab_username | Unknown |  |
| is_active | Unknown |  |
| is_staff | Unknown |  |
| last_login | Unknown |  |
| last_name | Unknown |  |
| show_existing_user_email_verification | Unknown |  |
| slack_connected | Unknown |  |

### environment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| connection_id | Unknown | FK |
| created_by_id | Unknown | FK |
| project_id | Unknown | FK |
| repository_id | Unknown | FK |
| credentials_id | Unknown |  |
| custom_branch | Unknown |  |
| dbt_project_subdirectory | Unknown |  |
| dbt_version | Unknown |  |
| name | Unknown |  |
| raw_dbt_version | Unknown |  |
| state | Unknown |  |
| supports_docs | Unknown |  |
| updated_at | Unknown |  |
| use_custom_branch | Unknown |  |

### job_execute_step

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| job_id | Unknown | PK, FK |
| execute_step | Unknown |  |

### job_schedule_date_day

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| job_id | Unknown | PK, FK |
| schedule_date_day | Unknown |  |

### job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| environment_id | Unknown | FK |
| project_id | Unknown | FK |
| created_at | Unknown |  |
| cron_humanized | Unknown |  |
| dbt_version | Unknown |  |
| deactivated | Unknown |  |
| deferring_environment_id | Unknown |  |
| deferring_job_definition_id | Unknown |  |
| execution_timeout_seconds | Unknown |  |
| generate_docs | Unknown |  |
| generate_sources | Unknown |  |
| is_deferrable | Unknown |  |
| job_type | Unknown |  |
| lifecycle_webhooks | Unknown |  |
| lifecycle_webhooks_url | Unknown |  |
| most_recent_completed_run | Json |  |
| most_recent_run | Json |  |
| name | Unknown |  |
| next_run | Unknown |  |
| next_run_humanized | Unknown |  |
| raw_dbt_version | Unknown |  |
| run_failure_count | Unknown |  |
| run_generate_sources | Unknown |  |
| schedule_cron | Unknown |  |
| schedule_date_type | Unknown |  |
| schedule_time_interval | Unknown |  |
| schedule_time_type | Unknown |  |
| settings_target_name | Unknown |  |
| settings_threads | Unknown |  |
| state | Unknown |  |
| triggers_custom_branch_only | Unknown |  |
| triggers_git_provider_webhook | Unknown |  |
| triggers_github_webhook | Unknown |  |
| triggers_schedule | Unknown |  |
| updated_at | Unknown |  |

### account_migration_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| account_has_static_subdomain | Unknown |  |
| account_identifier | Unknown |  |
| background_job_id | Unknown |  |
| completed_at | Unknown |  |
| failed_at | Unknown |  |
| is_minidump | Unknown |  |
| key | Unknown |  |
| started_at | Unknown |  |
| type | Unknown |  |

### account_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| assign_by_default | Unknown |  |
| name | Unknown |  |
| sso_mapping_group | Unknown |  |
| state | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| billing_email_address | Unknown |  |
| business_critical | Unknown |  |
| created_at | Unknown |  |
| develop_file_system | Unknown |  |
| develop_pod_memory_request_mebibyte | Unknown |  |
| developer_seat | Unknown |  |
| discovery_api_url | Unknown |  |
| enterprise_authentication_method | Unknown |  |
| enterprise_login_slug | Unknown |  |
| enterprise_unique_identifier | Unknown |  |
| explorer_seat | Unknown |  |
| git_auth_level | Unknown |  |
| identifier | Unknown |  |
| ip_restricted | Unknown |  |
| it_seat | Unknown |  |
| lock_cause | Unknown |  |
| lock_reason | Unknown |  |
| locked | Unknown |  |
| metronome_customer_id | Unknown |  |
| migration_scheduled_at | Unknown |  |
| name | Unknown |  |
| pending_cancel | Unknown |  |
| plan | Unknown |  |
| pod_memory_request_mebibyte | Unknown |  |
| queue_limit | Unknown |  |
| read_only_seat | Unknown |  |
| run_duration_limit_second | Unknown |  |
| run_locked_until | Unknown |  |
| run_slot | Unknown |  |
| salesforce_customer_id | Unknown |  |
| semantic_layer_graphql_api_url | Unknown |  |
| semantic_layer_jdbc_url | Unknown |  |
| semantic_layer_url | Unknown |  |
| starter_repo_url | Unknown |  |
| state | Unknown |  |
| static_subdomain | Unknown |  |
| static_url | Unknown |  |
| third_party_billing | Unknown |  |
| trial_end_date | Unknown |  |
| unlock_if_subscription_renewed | Unknown |  |
| unlocked_at | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- audit_log_event(account_id) → account(id)
- oauth_configuration(account_id) → account(id)
- project(freshness_job_id) → job(id)
- project(connection_id) → connection(id)
- project(docs_job_id) → job(id)
- project(repository_id) → repository(id)
- project(account_id) → account(id)
- run_step(run_id) → run(id)
- run_step(account_id) → account(id)
- run_trigger(run_id) → run(id)
- run(environment_id) → environment(id)
- run(job_id) → job(id)
- run(project_id) → project(id)
- run(account_id) → account(id)
- repository(project_id) → project(id)
- repository(account_id) → account(id)
- notification_on_failure(notification_id) → notification(id)
- notification_on_cancel(notification_id) → notification(id)
- notification_on_success(notification_id) → notification(id)
- notification(user_id) → users(id)
- notification(account_id) → account(id)
- connection(account_id) → account(id)
- webhook_event(job_id) → job(id)
- webhook_event(account_id) → account(id)
- ip_restriction_cidr(ip_restriction_id) → ip_restriction(id)
- ip_restriction(account_id) → account(id)
- run_artifact(account_id) → account(id)
- run_artifact(run_id) → run(id)
- run_result_timing(run_result_unique_id) → run_result(unique_id)
- run_result_timing(run_id) → run(id)
- run_result_timing(account_id) → account(id)
- run_result(account_id) → account(id)
- run_result(run_id) → run(id)
- auth_provider_user_groups(users_id) → users(id)
- group_permission(group_id) → groups(id)
- group_permission(project_id) → project(id)
- group_permission(account_id) → account(id)
- groups(account_id) → account(id)
- groups(permission_id) → permission(id)
- permission_statement(permission_id) → permission(id)
- permission(user_id) → users(id)
- permission(account_id) → account(id)
- environment(created_by_id) → users(id)
- environment(connection_id) → connection(id)
- environment(repository_id) → repository(id)
- environment(project_id) → project(id)
- environment(account_id) → account(id)
- job_execute_step(job_id) → job(id)
- job_schedule_date_day(job_id) → job(id)
- job(environment_id) → environment(id)
- job(project_id) → project(id)
- job(account_id) → account(id)
- account_migration_event(account_id) → account(id)
- account_group(account_id) → account(id)