Meltano

image.png

Hi, I am replicating data from MSSQL to BigQuery.

tap-mssql
target-bigquery

There are however column names with non-alphanumeric characters, and I am getting this error. How can I replace non-alphanumeric characters with underscores.

Probably possible by configuring <https://sdk.meltano.com/en/latest/stream_maps.html#constructing-the-stream-maps-config-object|stream maps> in your `target-bigquery` config (assuming `z3z1ma` variant).

> Similarly for targets, the received streams are processed by the `stream_maps` config setting prior to any Sink processing functions.

Something like

```  config:
    stream_maps:
      <stream>:
        <property>: self.encode().decode('ascii', errors='replace')```