[Solved] Given the dbt SQL snippet:SELECT data:customer->'address'->>'city' AS city FROM customersWhat will be the output type of the city column? | dbt

dbt - Advanced Patterns

Given the dbt SQL snippet:

SELECT data:customer->'address'->>'city' AS city FROM customers

What will be the output type of the city column?

AString/text

BJSON object

CInteger

DBoolean

Step-by-Step Solution

Solution:

Step 1: Understand JSON operators
-> extracts JSON object; ->> extracts text value from JSON key.
Step 2: Analyze the expression
data:customer->'address' extracts JSON object; ->>'city' extracts the city value as text/string.
Final Answer:
String/text -> Option A
Quick Check:
->> operator returns text/string [OK]

Quick Trick: ->> returns text, -> returns JSON object [OK]

Common Mistakes:

MISTAKES

Master "Advanced Patterns" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Given the dbt SQL snippet: