# dbt Mesh training - show data types macro not working

**URL:** <https://discourse.getdbt.com/t/dbt-mesh-training-show-data-types-macro-not-working/20409>\
**Category:** Help\
**Tags:** macros\
**Created:** [November 6, 2025, 11:19pm UTC](https://discourse.getdbt.com/t/dbt-mesh-training-show-data-types-macro-not-working/20409 "2025-11-06T23:19:14Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![FreeRangeDingo](https://avatars.discourse-cdn.com/v4/letter/f/b2d939/32.png) [@FreeRangeDingo](https://discourse.getdbt.com/u/FreeRangeDingo)\
**Post date:** [November 6, 2025, 11:19pm UTC](https://discourse.getdbt.com/t/dbt-mesh-training-show-data-types-macro-not-working/20409/1 "2025-11-06T23:19:14Z")

</div>

## The problem I’m having

I am doing the dbt Mesh training on dbt Learn. In the section on model contracts, a macro is provided to show you the data types in a give model. I have put this macro into a new file and replaced “model” with my model name and hit compile as the instructions indicate. It doesn’t error but it also doesn’t produce a result, just a blank line.

{% macro find\_datatypes(model) %}  
{% set cols=adapter.get\_columns\_in\_relation(model) %}  
{%- for col in cols %}  
- name: {{ col.name | lower }}  
data\_type: {{ col.dtype | lower }}  
{%- endfor %}  
{% endmacro %}

## The context of why I’m trying to do this

This seems useful, and I’d like it to work.

## What I’ve already tried

Checking the model name. Rereading the instructions.

## 

Is there something I am doing wrong?