View the original community article here
Last tested: Jan 26, 2021
We've seen this issue when a user is connecting to a specific table on BigQuery and it is based on a Google Sheet (made sure to share it with the Looker Service Account).
SOLUTION
The solution that worked as a charm is to check the schema detection on the connection to sheet and just set them all to string
This content is subject to limited support.