0

I would like to insert data into BQ via R. When I have a normal table everything is ok. The problem begins when I have to insert table which contains a map (nested/record repeated) column.

The column is defined like this:

enter image description here

I use bigrquery package and DBI like here:

dbWriteTable(
    con,
    "database.table",
    table,
    overwrite = FALSE,
    append = TRUE,
    row.names = FALSE
)

How should I define the customerdata column in R to insert it into Big Query? I've tried json and list but it didn't work. Although it could also be wrongly written json or list :)

enter image description here

I know that the example is not reproducible but it is rather not possible here or I have no idea how to create it.

Do you have any idea how to do this?

Marta
  • 3,032
  • 3
  • 17
  • 34
  • Can you share the JSON schema you are using? There are some JSON [limitations](https://cloud.google.com/bigquery/docs/loading-data-cloud-storage-json#limitations) when you load data into BigQuery. Are you sure your data does not fall under these limitations? – kiran mathew Dec 09 '22 at 12:52

0 Answers0