[Solved] Given this dbt model SQL for source table products: select id, name from {{ source('inventory', 'products') }} What will be the output if the source table has 3 rows with ids 1, 2, 3? | dbt

dbt - Project Organization

Given this dbt model SQL for source table products:

select id, name from {{ source('inventory', 'products') }}

What will be the output if the source table has 3 rows with ids 1, 2, 3?

AA table with only the id column.

BA table with 3 rows showing id and name columns.

CAn empty table because no filter is applied.

DAn error because source function is used incorrectly.

Step-by-Step Solution

Solution:

Step 1: Understand the query
The query selects id and name columns from the source table products which has 3 rows.
Step 2: Predict output
Since no filters or errors, output will be 3 rows with id and name columns.
Final Answer:
A table with 3 rows showing id and name columns. -> Option B
Quick Check:
Simple select from source returns all rows [OK]

Quick Trick: Selecting from source returns all matching rows [OK]

Common Mistakes:

MISTAKES

Master "Project Organization" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Given this dbt model SQL for source table products: