GCSToBigQueryOperator add columnNameCharacterMap to src_fmt_configs

[perttus]

Description

Please add columnNameCharacterMap as valid option to src_fmt_configsparameter for GCSToBigQueryOperator for CSV file format. This could be easily achieved just by editing the src_fmt_to_configs_mapping constants.

Use case/motivation

It already works with SQL but not with the operator.

LOAD DATA OVERWRITE `xxx`
FROM FILES (
    format = 'CSV',
    skip_leading_rows=1,
    column_name_character_map = 'V2',
    uris = [
      'gs://bucket/file.csv'
    ]
);

Related issues

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[boring-cyborg]

Thanks for opening your first issue here! Be sure to follow the issue template! If you are willing to raise PR to address this issue please do so, no need to wait for approval.

[guan404ming]

Hi, I think I could help with this~