[Solved] Which of the following is the correct syntax to use the pivot macro in dbt-utils? — Ans: {% set pivoted = dbt_utils.pivot(table=ref('sales'), column='month',... | dbt

dbt - Packages and Reusability

Which of the following is the correct syntax to use the pivot macro in dbt-utils?

A{% set pivoted = dbt_utils.unpivot(table=ref('sales'), column='month', value='revenue') %}

B{% set pivoted = dbt_utils.surrogate_key(columns=['id', 'date']) %}

C{% set pivoted = dbt_utils.pivot(table=ref('sales'), column='month', value='revenue') %}

D{% set pivoted = dbt_utils.pivot(table='sales', row='month', value='revenue') %}

Step-by-Step Solution

Solution:

Step 1: Identify correct macro and parameters
The pivot macro requires a table, a column to pivot on, and a value column.
Step 2: Check syntax correctness
{% set pivoted = dbt_utils.pivot(table=ref('sales'), column='month', value='revenue') %} uses table=ref('sales'), column='month', and value='revenue', which is correct.
Final Answer:
{% set pivoted = dbt_utils.pivot(table=ref('sales'), column='month', value='revenue') %} -> Option C
Quick Check:
pivot syntax = table, column, value [OK]

Quick Trick: pivot needs table, column, and value parameters [OK]

Common Mistakes:

MISTAKES

Master "Packages and Reusability" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Which of the following is the correct syntax to use the pivot macro in dbt-utils?