While trying to load data from a CSV file in GCS using From File process, the first row from the file is always missing in BQ. What would be the possible reason for this?

Completed

Follow

Mahesh Shenoy

December 24, 2021 04:20

While trying to load data from a CSV file in GCS using From File process, the first row from the file is always missing in BQ. Not sure whether this is a known issue. 

2

• 

  Mahesh Shenoy December 24, 2021 04:27

  on second thought  - one reason could be, if the header toggle is turned on, it will consider first row as header. Labinot Dvorani hope am right

   

  0

  Comment actions Permalink
• 

  Labinot Dvorani December 24, 2021 10:04

  Mahesh Shenoy that's correct column headers would cause this. 

  0

  Comment actions Permalink

Please sign in to leave a comment.