Error in incremental model using a field name called location

[YiftachLevy]

We have an incremental model with a filed name that called location.
It seems to be a reserved name in impala so we create the table with the following command:

,cast(s.`location` as string) `location`

This seems to work in impala but it fails in dbt while using incremental model because dbt an insert creates a script which use location without the quotes.

error:

11:58:34    Encountered: LOCATION
11:58:34    Expected: DEFAULT, IDENTIFIER
11:58:34    
11:58:34    CAUSED BY: Exception: Syntax error

Example from the compiled code

insert into table_name (location)
(select location from table_name__dbt_tmp)

Versions:
dbt-core 1.4.9
dbt-impala 1.4.0

[tovganesh]

Apparently, "location" is a keyword in Impala: https://impala.apache.org/docs/build/html/topics/impala_reserved_words.html
Probably the solution would be to add quote to the fields.

[YiftachLevy]

Thank you for the quick answer.
Using the quotes works for normal tables:

    config(
        materialized='table'
    )

It fails however in incremental moldes

    config(
        materialized='incremental'
    )

The quotes are not passed in the select clause in the insert statement from the temp to the table

insert into table_name (location)
(select **location** from table_name__dbt_tmp)

Is there any workaroud/dbt-macro for passing the quotes?