How to use * char in the column name?

[masao]

The problem I’m having

We have a column name called “＊abc” in Redsift database.
When we try to execute dbt run --select, we get following error.

operator does not exist: character varying * double precision

The model we execute contains like following.

SELECT t0.＊abc
FROM test as t0

In Redshift, we can execute aboe query, but, dbt dose not allow us to execute.

Do you have any suggestion for this?

Regards,

[brunoszdl]

Try

SELECT t0."＊abc"

or

SELECT t0.`＊abc`

not sure if it will work, I am not familiarized with redshift, but I would try it

[a_slack_user]

Possibly useful: https://docs.getdbt.com/reference/resource-properties/quote

_{Note: @Owen originally posted this reply in Slack. It might not have transferred perfectly.}

[masao]

@brunoszdl
Thank you very much for your help.
I could solve the issue.
Regards,