ORA-00911: invalid character 00911. 00000 - "invalid character"

[fatemehramezani]

Hi,
I tried to start working with dbt and connect to Oracle database, but looks dbt tries to add a view with invalid character:

Error report - ORA-00911: invalid character 00911. 00000 - "invalid character" *Cause: identifiers may not start with any ASCII character other than letters and numbers. $#_ are also allowed after the first character. Identifiers enclosed by doublequotes may contain any character other than a doublequote. Alternative quotes (q'#...#') cannot use spaces, tabs, or carriage returns as delimiters. For all other contexts, consult the SQL Language Reference Manual. *Action:

the generated view creation is:

create or replace view app.stg_inventory_a​ as
    with source as (
    select * from app.inventory_stock_a
), ...

there is an invisible character after _a​ and need to remove it manually

[fatemehramezani]

I found the solution, it is coming from the file name and there is an invisible character in the file name