calling macro in a model

In-Depth Discussions
1

hi all , i have recently started using dbt . Looking for help

this is the macro i wrote to compare mobno column.

{% macro get_cust_name(mobno) %}

{% set query %}
select name from customer_test where mobno = ‘{{ mobno }}’
{% endset %}

{% do run_query(query) %}
{% endmacro %}

I am calling abov emacro in a model like so

select
*,
{{ get_cust_name(‘00000’) }}
from customer_test

But when i try to build the model it gives me error
6:19:21 1 of 1 START sql view model TEST2.macro2_test … [RUN]
06:19:22 1 of 1 ERROR creating sql view model TEST2.macro2_test … [ERROR in 1.00s]
06:19:22
06:19:22 Finished running 1 view model in 0 hours 0 minutes and 3.24 seconds (3.24s).
06:19:22
06:19:22 Completed with 1 error and 0 warnings:
06:19:22
06:19:22 Database Error in model macro2_test (models\macro2_test.sql)
06:19:22 001003 (42000): SQL compilation error:
06:19:22 syntax error line 12 at position 0 unexpected ‘from’.
06:19:22 compiled Code at target\run\new1\models\macro2_test.sql
06:19:22
06:19:22 Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1

waiting for responses