0

I'm working with CSV files in an R notebook. To upload the data I'm using a bash chunk and bq command. I'd like to be able to do it in an R chunk.

I use bigrquery and dbplyr for my BigQuery work in R. But bigrquery and DBI don't seem to have methods to allow a disk file to pass through to BigQuery without first creating a dataframe.

Is there a way to do this other than a bash chunk or system command?

abalter
  • 9,663
  • 17
  • 90
  • 145
  • There are some ways that I found how you can load a CSV file with R into BigQuery. The approaches are the next ones: [1]https://rdrr.io/cran/bigQueryR/man/bqr_upload_data.html [2]https://cloud.google.com/bigquery/docs/batch-loading-data#loading_data_from_local_files [3]https://cloud.google.com/bigquery/docs/loading-data-cloud-storage-csv#loading_csv_data_into_a_table – Jose Gutierrez Paliza Oct 15 '21 at 22:26
  • I'm aware of bigqueryR, but it isn't being maintained so I'm reluctant to put it in a pipeline. – abalter Oct 16 '21 at 01:28

0 Answers0