How to use * char in the column name?

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?



SELECT t0."*abc"


SELECT t0.`*abc`

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

1 Like

Possibly useful:

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

Thank you very much for your help.
I could solve the issue.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.