This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Load csv without any header and later assign header from separate file.

Posted on 05-05-2022 10:13 AM
asinghal
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hi

I have a big csv loaded in GCS (~143GB) but it does not have any header row (csv has only the data). I have the header file separately in GCS (as well as on my local machine). 

Is there a way that I can load this csv (from GCS) as  a table in BigQuery and get the column names from the header file that is also there in GCS separately? 

Or how can I provide manual schema in Bigquery when I create the table? 

P.S. : My data has 900 columns so I cannot type in everything. It has to be either copy-paste or directly reading from the file. 

0 1 2,809
Topic Labels
0 Likes
1 REPLY 1