I am trying to run simple SQL query (select * from table_name) in BigQuery and I am getting the following error:
Error while reading table: table_name, error message: Error detected while parsing row starting at position: 219019. Error: Missing close double quote (“) character.
I was able to run this query successfully last week, so I don’t understand what would have changed. When I have looked it up, people are saying it is a newline character issue, but their experience with the error is when uploading data. This table I am querying comes from a BI connector, so there should be consistency each day in the process.
Why would I receive this error suddenly and how do I determine what changed to cause it?