# How do we pass column values into dbt macros
**URL:** https://discourse.getdbt.com/t/how-do-we-pass-column-values-into-dbt-macros/9782
**Category:** Help
**Created:** [August 31, 2023, 1:07am UTC](https://discourse.getdbt.com/t/how-do-we-pass-column-values-into-dbt-macros/9782 "2023-08-31T01:07:04Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@nousername1](https://discourse.getdbt.com/u/nousername1)
#### Post date: [August 31, 2023, 1:07am UTC](https://discourse.getdbt.com/t/how-do-we-pass-column-values-into-dbt-macros/9782/1 "2023-08-31T01:07:04Z")
Need to strip/format an address field in a customer account. Trying to pass the value of the customer account street column into a dbt/jinja macro to parse
Example query:
```auto
with
test as (
SELECT
first_name, last_name,
{{ format_street(customer_account.street) }} as account_street,
city, region, postal_code, country
FROM {{ source(db, table }} customer_account
LIMIT 5
)
```
Macro example just to log what the street even looks like:
```auto
{% macro format_street(row_value) %}
{{ log(row_value, info=true) }}
{% endmacro %}
```
## What I’ve already tried
Trying below line:
```auto
{{ format_street('street') }} as account_street
```
logs the column name into the macro and workable with sql, but I’d need the actual string column value to use with jinja
Trying below line:
```auto
{{ format_street('customer_account.street') }} as account_street
```
logs the literal string “customer\_account.street” into the macro and not the column value
Trying without quotations:
```auto
{{ format_street(customer_account.street) }} as account_street
```
throws error “‘customer\_account’ is undefined. This can happen when calling a macro that does not exist. Check for typos and/or install package dependencies with “dbt deps”.”
#
#
Is there a specific format that I’m missing? I’d just need the column value passed into a macro. Have been super hard to find further information on this. Any help is much appreciated in advance
---
### Author:  [@stephen](https://discourse.getdbt.com/u/stephen)
#### Post date: [August 31, 2023, 4:32am UTC](https://discourse.getdbt.com/t/how-do-we-pass-column-values-into-dbt-macros/9782/2 "2023-08-31T04:32:04Z")
> [@nousername1](#):
>
> ```auto
> {{ format_street('customer_account.street') }} as account_street
>
> ```
That would be the correct way to pass the column name value to the macro. The problem is to debug you are using another macro.
If you want to truly see the effect of the macro, I would suggest adding a simple `trim` statement to it like:-
```auto
{% macro format_street(column_name) %}
trim({{ column_name }})
{% endmacro %}
```
And then check the compiled SQL.
I am guessing from the way you named the argument to the macro (`row_value `) you were confusing it with working on the actual data instead of just creating the SQL to work on it.
---
### Author:  [@nousername1](https://discourse.getdbt.com/u/nousername1)
#### Post date: [August 31, 2023, 7:20am UTC](https://discourse.getdbt.com/t/how-do-we-pass-column-values-into-dbt-macros/9782/3 "2023-08-31T07:20:18Z")
Hi,
Thanks for replying
I don’t quite understand the last part of your statement. I do need to work on the actual data ( will transform it in the macro with jinja )
If I used below line inside the sql select
```auto
{{ format_street('customer_account.street') }} as account_street
```
The log value of the macro is “customer\_account.street” vs the actual value of the row column. Though I think the data is actually passed in correctly, I’m just not able to use it in jinja? The end use case for this macro is I’d need to check the length of the value passed, and if it begins with a certain character, to strip it out
---
### Author:  [@stephen](https://discourse.getdbt.com/u/stephen)
#### Post date: [August 31, 2023, 12:38pm UTC](https://discourse.getdbt.com/t/how-do-we-pass-column-values-into-dbt-macros/9782/4 "2023-08-31T12:38:31Z")
For a 10,000 feet overview, the way dbt works, the Jinja-SQL we write is converted into SQL for your target database in the compile step, and the run step basically runs that SQL.
Your macros are replaced with SQL code at the compile time itself, they don’t work on the data in your database. For the example the modified macro I mentioned in my previous post (which you completely ignored) when used in a dbt model would have resulted in the following :-
```auto
{% macro format_street(column_name) %}
trim({{ column_name }})
{% endmacro %}
```
The dbt model code:-
```auto
with
test as (
SELECT
first_name, last_name,
{{ format_street("customer_account.street") }} as account_street,
city, region, postal_code, country
FROM {{ source(db, table }} customer_account
LIMIT 5
)
select * from test;
```
The above SQL when doing (dbt compile or dbt run) would get transformed to:-
```auto
with
test as (
SELECT
first_name, last_name,
trim(customer_account.street) as account_street,
city, region, postal_code, country
FROM customer_account
LIMIT 5
)
select * from test;
```
When dbt runs the query in your target warehouse / db, the above SQL would be the one sent, and as you can see, there is no jinja code or macros here.
So to summarise, in the jinja, you don’t work with the actual values in the database, you use the jinja to generate the SQL code which will work on the values in the database.
---
### Author:  [@nousername1](https://discourse.getdbt.com/u/nousername1)
#### Post date: [August 31, 2023, 11:36pm UTC](https://discourse.getdbt.com/t/how-do-we-pass-column-values-into-dbt-macros/9782/5 "2023-08-31T23:36:23Z")
Hi stephen,
Thanks for replying. Your macro suggestion wasn’t ignored, that’s how I knew the value was getting passed into the macro by changing the value like:
```auto
{{ format_street('customer_account.first_name') }}
```
Would pass the name as value inside db with the trim function
Can I confirm that the column value passed into dbt macro is not workable in a jinja template?