I am setting up a BigQuery transfer service to transfer a CSV stored in a GCS bucket into BigQuery.
However, I don't need all the columns in the CSV file. Is there a way of limiting the columns I transfer without having to manually remove the columns before the transfer?
Or, if I limited the columns in my BQ table to the ones I need, will BQ just ignore the other columns in the CSV file?
I have read the relevant page in the documentation but there is no mention of limiting columns.