[Solved] Given this dbt model SQL snippet, what will be the output of final_count?... Given this dbt model SQL snippet, what will be the output of final_count? | dbt

dbt - Advanced Patterns

Given this dbt model SQL snippet, what will be the output of final_count?

WITH filtered_data AS (
  SELECT * FROM users WHERE active = TRUE
),
count_data AS (
  SELECT COUNT(*) AS final_count FROM filtered_data
)
SELECT final_count FROM count_data

AThe number of active users

BThe total number of users

CA list of active users

DAn error due to missing GROUP BY

Step-by-Step Solution

Solution:

Step 1: Analyze the filtering step
The first CTE filters users where active is TRUE, so only active users remain.
Step 2: Analyze the counting step
The second CTE counts rows from filtered_data, so it counts active users.
Final Answer:
The number of active users -> Option A
Quick Check:
final_count = count of active users [OK]

Quick Trick: CTEs can filter then count data stepwise [OK]

Common Mistakes:

MISTAKES

Confusing total users with active users count
Expecting a list instead of a count
Thinking GROUP BY is required for COUNT(*)

Master "Advanced Patterns" in dbt

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More dbt Quizzes

Given this dbt model SQL snippet, what will be the output of final_count?

Step 1: Analyze the filtering step

Step 2: Analyze the counting step

Final Answer:

Quick Check:

Want More Practice?