BigQuery is a low cost analytics data warehouse. Their are some Limitations while loading CSV data from Cloud Storage into BigQuery. Here you find Loading CSV data into a BigQuery table.
We are using the cloud storage bucket to store the data and BigQuery to upload the data from the Storage bucket and merge the files...

















