dbt Cloud

Explore the interactive ERD

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	PKFK
`on_failure`	Unknown

notification_on_cancel

Column	Type	Keys
`index`	Unknown	PK
`notification_id`	Unknown	PKFK
`on_cancel`	Unknown

notification_on_success

Column	Type	Keys
`index`	Unknown	PK
`notification_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`run_id`	Unknown	PKFK

run_result_timing

Column	Type	Keys
`index`	Unknown	PK
`account_id`	Unknown	PKFK
`run_id`	Unknown	PKFK
`run_result_unique_id`	Unknown	PKFK
`completed_at`	Unknown
`name`	Unknown
`started_at`	Unknown

run_result

Column	Type	Keys
`unique_id`	Unknown	PK
`account_id`	Unknown	PKFK
`run_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`execute_step`	Unknown

job_schedule_date_day

Column	Type	Keys
`index`	Unknown	PK
`job_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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