dbt

dbt (data build tool) is an open-source tool that enables data analysts and engineers to transform raw data into organized, usable datasets through SQL-based transformations. It automates the deployment and versioning of data models, ensuring consistent and reliable data pipelines.

Default hierarchy

In the chart below, you can see how dbt objects are organized. Objects are in green and folders are in yellow.

Object Types

Dawiso integrates from dbt:

Project

Maps to dbt Project object type.

Source Attribute	Target Attribute in Dawiso
name	Name
id	Project Id
state	State
group_permissions	Group Permissions
semantic_layer_config_id	Semantic Layer Config Id
skipped_setup	Skipped Setup
docs_job_id	Documentation Job Id
docs_job	Documentation Job
freshness_job_id	Freshness Job Id
freshness_job	Freshness Job
account_id	Account Id
connection_id	Connection Id
connection	connection
created_at	Created
updated_at	Updated
project_subdirectory	Subdirectory
repository_id	Repository Id
repository	Repository

Environment

Maps to dbt Environment object type.

Source Attribute	Target Attribute in Dawiso
name	Name
description	Scanned Description
id	Environment Id
use_custom_branch	Use Custom Branch
custom_branch	Custom Branch
supports_docs	Supports Docs
state	State
created_at	Created
updated_at	Updated
project	Project
credentials	Credentials
account_id	Account Id
type	Type
deployment_type	Deployment Type
credentials_id	Credentials Id
extended_attributes_id	Extended Attributes Id
is_deferrable	Is Deferrable
dbt_version	Dbt Version
raw_dbt_version	Raw Dbt Version

Job

Maps to dbt Job object type.

Source Attribute	Target Attribute in Dawiso
name	Name
description	Scanned Description
account_id	Account Id
deferring_environment_id	Deferring environment_id
lifecycle_webhooks	Lifecycle Webhooks
lifecycle_webhooks_url	Lifecycle Webhooks_url
generate_docs	Generate Docs
run_generate_sources	Run Generate Sources
triggers	Triggers
execute_steps	Execute Steps
schedule	Schedule
settings	Settings
execution	Execution
project_id	Project Id
environment	Environment
account	Account
project	Project
most_recent_completed_run	Most Recent Completed Run
most_recent_run	Most Recent Run
is_deferrable	Is Deferrable
deactivated	Deactivated
run_failure_count	Run Failure Count
job_type	Job Type
triggers_on_draft_pr	Triggers On Draft Pr
environment_id	Environment Id
generate_sources	Generate Sources
cron_humanized	Cron Humanized
next_run	Next Run
next_run_humanized	Next Run Humanized
dbt_version	Dbt Version
raw_dbt_version	Raw Dbt Version
state	State
created_at	Created
updated_at	Updated
deferring_job_definition_id	Deferring Job Definition Id

Exposure

Maps to dbt Exposure object type.

Source Attribute	Target Attribute in Dawiso
name	Name
description	Scanned Description
run_id	Run Id
tags	Tags
manifest_generated_at	Manifest Generated At
package_name	Package Name
owner_name	OwnerName
owner_email	OwnerEmail
exposure_type	Type
url	Url
maturity	Maturity
depends_on	Depends On
parents	Parent Resources
account_id	Account Id
parents_models	Parents Models
parents_sources	Parents Sources
project_id	Project Id
environment_id	Environment Id
job_id	Job Id
resource_type	Resource Type
unique_id	Unique Id
meta	Meta
dbt_version	Dbt Version

Model

Maps to dbt Model object type.

Source Attribute	Target Attribute in Dawiso
name	Name
description	Scanned Description
run_id	Run Id
tags	Tags
database	Database
schema	Schema
alias	Alias
invocation_id	Invocation Id
args	Args
error	Error
status	Status
skip	Skip
compile_started_at	Compile Started At
account_id	Account Id
compile_completed_at	Compile Completed At
execute_started_at	Execute Started At
execute_completed_at	Execute Completed At
execution_time	Execution Time
thread_id	Thread Id
run_generated_at	Run Generated At
run_elapsed_time	Run Elapsed Time
depends_on	Depends On
package_name	Package Name
type	Type
project_id	Project Id
owner	Owner
comment	Comment
children_l1	Children L1
raw_sql	Raw Sql
compiled_sql	Compiled Sql
run_results	Run Results
parents_models	Parents Models
parents_sources	Parents Sources
environment_id	Environment Id
job_id	Job Id
resource_type	Resource Type
unique_id	Unique Id
meta	Meta
dbt_version	Dbt Version

Model Column

Maps to dbt Model Column object type.

Source Attribute	Target Attribute in Dawiso
name	Name
description	Scanned Description
index	Index
type	Data Type
comment	Comment
meta	Meta
tags	Tags

Model Statistic

Maps to dbt Model Statistic object type.

Source Attribute	Target Attribute in Dawiso
name	Name
description	Scanned Description
id	Id
include	Include
value	Value

Model Test

Maps to dbt Model Test object type.

Source Attribute	Target Attribute in Dawiso
name	Name
description	Scanned Description
resource_type	Resource Type
depends_on	Depends On
fail	Fail
warn	Warn
skip	Skip
raw_sql	Raw Sql
compiled_sql	Compiled Sql
unique_id	Unique Id
meta	Meta
dbt_version	Dbt Version
tags	Tags
state	State
column_name	Column Name
status	Status
error	Error

Source

Maps to dbt Source object type.

Source Attribute	Target Attribute in Dawiso
name	Name
description	Scanned Description
run_id	Run Id
account_id	Account Id
project_id	Project Id
environment_id	Environment Id
job_id	Job Id

Source Table

Maps to dbt Source Table object type.

Source Attribute	Target Attribute in Dawiso
name	Name
description	Scanned Description
run_id	Run Id
tags	Tags
database	Database
schema	Schema
identifier	Identifier
source_name	Source Name
source_description	Source Description
max_loaded_at	Max Loaded At
snapshotted_at	Snapshotted At
max_loaded_at_time_ago_in_s	Max Loaded At Time Ago Sec
run_generated_at	Run Generated At
account_id	Account Id
run_elapsed_time	Run Elapsed Time
state	Freshness State
freshness_checked	Freshness Checked
loader	Loader
type	Type
owner	Owner
comment	Comment
criteria	Criteria
children_l1	Children L1
project_id	Project Id
environment_id	Environment Id
job_id	Job Id
resource_type	Resource Type
unique_id	Unique Id
meta	Meta
dbt_version	Dbt Version

Source Table Column

Maps to dbt Source Table Column object type.

Source Attribute	Target Attribute in Dawiso
name	Name
description	Scanned Description
index	Index
type	Data Type
comment	Comment
meta	Meta
tags	Tags

Source Table Statistic

Maps to dbt Source Table Statistic object type.

Source Attribute	Target Attribute in Dawiso
name	Name
description	Scanned Description
id	Id
include	Include
value	Value

Source Table Test

Maps to dbt Source Table Test object type.

Source Attribute	Target Attribute in Dawiso
name	Name
description	Scanned Description
resource_type	Resource Type
depends_on	Depends On
fail	Fail
warn	Warn
skip	Skip
raw_sql	Raw Sql
compiled_sql	Compiled Sql
unique_id	Unique Id
meta	Meta
dbt_version	Dbt Version
tags	Tags
state	State
column_name	Column Name
status	Status
error	Error

Relations

From Object Type	Relation Type	To Object Type
Exposure	depends on / is dependency for	Model
Model	depends on / is dependency for	Model
Model	depends on / is dependency for	Source Table

Relations diagram