Search⌘ K
AI Features
Home
Courses
Learn Data Build Tools ( DBT )

Solution: Join Two Models

Explore how to join two dbt models by using the ref function to reference and manage dependencies. Understand how dbt executes models in the correct sequence to ensure reliable data joins. This lesson helps you apply best practices for organizing and combining data sources within dbt.

We'll cover the following...

Solution

Let’s review the solution to the problem presented in the previous lesson.

shop:
  outputs:
    dev:
      dataset: {{dataset_name}}
      job_execution_timeout_seconds: 300
      job_retries: 1
      keyfile: credentials.json
      location: {{dataset_location}}
      method: service-account
      priority: interactive
      project: {{project_id}}
      threads: 1
      type: bigquery
  target: dev
# Enter your new profile here
Solution code: Joining two dbt models
...