Error while reading data

[Ken1010]

Hi, 

I'm trying to create an external table linked to a bucket, the initial load works fine but as the files in the bucket grows, I get the following error. There are files that drop into the bucket every 30 mins.

Error while reading data, error message: Too many values in line. Found 18 column(s) when expecting 1.; line_number: 1 byte_offset_to_start_of_line: 0

I'm relatively new to the GCP, so I not sure where and how to resolve this issue, any help would be appreciated.

[kolban]

Welcome to the world of GCP!!!   Let's see how we can help.  What I think I'd like to see is the definition of the table that is mapped to the Google Cloud Storage bucket.  This will tell us what kinds of files are expected to be found in the bucket (eg. CSV, JSON etc) and how the content is expected to be parsed.  The message is telling us that it has found 18 columns (ok) but 1 was expected (odd).  I want to see what the schema of the table looks like.  Also, if you are adding new files ... let's take a look at the content of that file.  Please do NOT post sensistive data.  I'll leave it to you on how you decide to obfuscate the sample (eg. dummy values retaining the same structures).