Skip to content

Latest commit

 

History

History
414 lines (208 loc) · 6.38 KB

docs.md

File metadata and controls

414 lines (208 loc) · 6.38 KB

{% docs command_invocation_id %}

The invocation_id is a UUID generated by dbt for each invocation. It can be used to link records which were generated by the same dbt invocation.

{% enddocs %}

{% docs node_id %}

Unique node identifier.

{% enddocs %}

{% docs name %}

Name of the node.

{% enddocs %}

{% docs schema %}

Configured schema for the node.

{% enddocs %}

{% docs package_name %}

Name of the dbt package which contains the node.

{% enddocs %}

{% docs total_node_runtime %}

Total time spent executing this node (seconds).

{% enddocs %}

{% docs compile_started_at %}

Timestamp when the node started compiling.

{% enddocs %}

{% docs depends_on_nodes %}

Array of node identifiers that this node depends on in the execution graph.

{% enddocs %}

{% docs status %}

Represents the execution status of a node, can be success, failure, or error.

{% enddocs %}

{% docs query_completed_at %}

Timestamp when the node's SQL query completed.

{% enddocs %}

{% docs materialization %}

The materialization of the model.

{% enddocs %}

{% docs database %}

The configured database for the node.

{% enddocs %}

{% docs rows_affected %}

Number of rows affected by the model execution.

{% enddocs %}

{% docs bytes_processed %}

Number of bytes processed by the model execution.

{% enddocs %}

{% docs thread_id %}

Which thread executed this node? E.g. Thread-1

{% enddocs %}

{% docs path %}

Path to the model on the local filesystem.

{% enddocs %}

{% docs was_full_refresh %}

Boolean flag indicating whether the nodes run was a full refresh or not.

{% enddocs %}

{% docs checksum %}

Checksum of the model.

{% enddocs %}

{% docs seed_execution_id %}

Execution ID of the seed node.

{% enddocs %}

{% docs test_execution_id %}

Execution ID of the test node.

{% enddocs %}

{% docs snapshot_execution_id %}

Execution ID of the snapshot node.

{% enddocs %}

{% docs model_execution_id %}

Execution ID of the model node.

{% enddocs %}

{% docs loader %}

Describes the tool that loads this source into your warehouse.

{% enddocs %}

{% docs freshness %}

The specified freshness of the source model.

{% enddocs %}

{% docs url %}

The URL of the BI tool where the data defined by the exposure can be viewed.

{% enddocs %}

{% docs identifier %}

Source identifier.

{% enddocs %}

{% docs source_name %}

Source name.

{% enddocs %}

{% docs test_path %}

Path to the yaml (SQL in case of a singular test) file describing the test.

{% enddocs %}

{% docs tags %}

Tags used in resource selection associated with the node.

{% enddocs %}

{% docs strategy %}

Snapshot "strategies" define how dbt knows if a row has changed. There are two strategies built-in to dbt — timestamp and check.

{% enddocs %}

{% docs failures %}

Test failures. Value is 1 if the test failed, 0 if successful.

{% enddocs %}

{% docs loaded_at_field %}

A column name (or expression) that returns a timestamp indicating freshness.

{% enddocs %}

{% docs type %}

Exposure type; one of dashboard, notebook, analysis, ml, application (used to organize on docs site)

{% enddocs %}

{% docs description %}

Node description.

{% enddocs %}

{% docs maturity %}

Exposure maturity; one of high, medium, low.

{% enddocs %}

{% docs owner %}

Owner of the exposure, usually an email address.

{% enddocs %}

{% docs source_execution_id %}

Execution ID of the source node.

{% enddocs %}

{% docs exposure_execution_id %}

Execution ID of the exposure node.

{% enddocs %}

{% docs dbt_version %}

Installed version of dbt that is currently running.

{% enddocs %}

{% docs project_name %}

Name for the root-level project which is being run by dbt.

{% enddocs %}

{% docs run_started_at %}

The start timestamp of the dbt execution which generated the record.

{% enddocs %}

{% docs dbt_command %}

dbt command of this run.

{% enddocs %}

{% docs full_refresh_flag %}

Boolean flag indicating whether the dbt run was in full refresh mode or not.

{% enddocs %}

{% docs target_profile_name %}

The name of the active profile.

{% enddocs %}

{% docs target_name %}

The name of the active target.

{% enddocs %}

{% docs target_schema %}

The name of the target dbt schema.

{% enddocs %}

{% docs target_threads %}

The number of threads in use by dbt.

{% enddocs %}

{% docs dbt_cloud_project_id %}

The ID of the dbt Cloud Project for this run.

{% enddocs %}

{% docs dbt_cloud_job_id %}

The ID of the dbt Cloud Job for this run.

{% enddocs %}

{% docs dbt_cloud_run_id %}

The ID of this particular run.

{% enddocs %}

{% docs dbt_cloud_run_reason_category %}

The "category" of the trigger for this run.

{% enddocs %}

{% docs dbt_cloud_run_reason %}

The specific trigger for this run.

{% enddocs %}

{% docs env_vars %}

Key-value pairs of environment variables to be capture.

{% enddocs %}

{% docs dbt_vars %}

Key-value pairs of project variables to be capture.

{% enddocs %}

{% docs last_full_refresh_run_completed_at %}

Timestamp when the node's SQL query completed on the last full (non-incremental) run.

{% enddocs %}

{% docs last_full_refresh_run_rows_affected %}

Number of rows affected by the node's last full (non-incremental) run.

{% enddocs %}

{% docs last_full_refresh_run_bytes_processed %}

Number of bytes processed by the node's last full (non-incremental) run.

{% enddocs %}

{% docs last_full_refresh_run_total_runtime %}

Total time spent executing the node's last full (non-incremental) run (seconds).

{% enddocs %}

{% docs last_run_completed_at %}

Timestamp when the node's SQL query completed on the last run.

{% enddocs %}

{% docs last_run_rows_affected %}

Number of rows affected by the node's last run.

{% enddocs %}

{% docs last_run_bytes_processed %}

Number of bytes processed by the node's last run.

{% enddocs %}

{% docs last_run_total_runtime %}

Total time spent executing the node's last run (seconds).

{% enddocs %}

{% docs meta %}

The meta field of the config associated with the node.

{% enddocs %}

{% docs invocation_args %}

Key-value pairs of args passed to invocation.

{% enddocs %}

{% docs dbt_custom_envs %}

Key-value pairs of environment variables passed to invocation that have the prefix DBT_ENV_CUSTOM_ENV_

{% enddocs %}

{% docs alias %}

Alias of the node.

{% enddocs %}

{% docs message %}

Result report, based on information returned from the database

{% enddocs %}

{% docs adapter_response %}

Response provided by the adapter as JSON.

{% enddocs %}

{% docs all_results %}

All results as a JSON blob

{% enddocs %}