[Solved] Which of the following is the correct syntax to perform a full outer join in dbt's SQL model?SELECT * FROM source_a a FULL OUTER JOIN source_b b ON a.id = b.id | dbt

dbt - Advanced Patterns

Which of the following is the correct syntax to perform a full outer join in dbt's SQL model?

SELECT * FROM source_a a
FULL OUTER JOIN source_b b
ON a.id = b.id

ASELECT * FROM source_a a FULL OUTER JOIN source_b b ON a.id = b.id

BSELECT * FROM source_a a INNER JOIN source_b b ON a.id = b.id

CSELECT * FROM source_a a LEFT JOIN source_b b ON a.id = b.id

DSELECT * FROM source_a a CROSS JOIN source_b b

Step-by-Step Solution

Solution:

Step 1: Identify the join type needed for fan-in
Multi-source fan-in requires a full outer join to keep all records from both sources.
Step 2: Match the syntax for full outer join
The correct syntax is FULL OUTER JOIN with the join condition.
Final Answer:
SELECT * FROM source_a a FULL OUTER JOIN source_b b ON a.id = b.id -> Option A
Quick Check:
Full outer join syntax = SELECT * FROM source_a a FULL OUTER JOIN source_b b ON a.id = b.id [OK]

Quick Trick: Full outer join keeps all rows from both tables [OK]

Common Mistakes:

MISTAKES

Master "Advanced Patterns" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Which of the following is the correct syntax to perform a full outer join in dbt's SQL model?