Hello. I am working on replicating a database on M...
# best-practices
t
Hello. I am working on replicating a database on MSSQL to BigQuery. The issue I'm encountering is column names with special characters from the source. I tried adding a SQL script in the extractor config in the yml file to clean(remove special characters from column names) the columns to conform to what is allowed on BigQuery but that has not worked. Any suggestions?
h
I had also hit this with '+' characters. Fortunately, we did not need those tables. I presume this is a tap issue where the identifier isn't being surrounded with quotes.