Error: CSV table encountered too many errors, giving up. Rows: 1; errors: 1. Please look into the errors[] collection for more details

[flaviagdo]

Knowledge Drop

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.