unit test: numeric column name in source

Help
,
1

The problem I’m having

I want to write a unit test for a dbt model. However, one of the source tables has columns with numbers as name, e.g. “200”.
The unit test results in an error, since it tries to run this sql query:

select
try_cast('123' as character varying(16777216))
as othercolumn,
try_cast(null as character varying(1))
     as 200

The context of why I’m trying to do this

I cannot change the source table, so I have to live with numbers as column names.

What I’ve already tried

I tried to explicitly assign the columns a value in input, although they are not used in my model

      - input: source('SOURCE_SCHEMA', 'SOURCE_TABLE')
        rows:
          - othercolumn: '123'
            "200": 0

This has no effect. The sql still looks like this:

select
try_cast('123' as character varying(16777216))
as othercolumn,
try_cast('0' as character varying(1))
     as 200

Error messages

14:05:10    Runtime Error in unit_test ut_mymodel (models\mymodel.yml)
  An error occurred during execution of unit test 'ut_mymodel'. There may be an error in the unit test definition: check the data types.
   Database Error
    001003 (42000): SQL compilation error:
    syntax error line 110 at position 8 unexpected '200'.

My Question

Is there a way to use numbers as column names in dbt unit tests? For example, is there a setting to force quotes around column names in the compiled unit test code?

2

Topic is not relevant for me anymore: Source change the names of the columns to start with letters.