BigQuery JSON format

[gerardo_lalo4]

Hi community!

I need all your knowledge because I'm downloading data from BigQuery using the BigQuery connector and it works fine  but at the moment that I check the fields some have this format: 

{"v":{"f":[{"v":"5c82dfdef82cf17a0d61b2d8"},{"v":"PEDRO DANIEL DEL PUERTO ROBLES"},{"v":"5c82dfdef82cf17a0d61b2d6"},{"v":"119547"}]}}

I read about a REST connector that is used to manage JSON fields (which I think is this case) but I don't have experience using it.

Do I need to do a combination of the 2 connectors or what is the best way to manage the fields with the JSON format?

Thank's!!

[roy_menger]

Hello,

Did you ever find a solution for this? 

[MarcoWedel · Accepted solution]

maybe loading From_Field after the initial load?

LOAD *
FROM_FIELD
(Table, Field)
(json, utf8, no labels);

[gitguto]

I had the same problem and found a good workaround.

I found out that changing the name of the table I'm loading data from, solves the problem.

When I load, it comes like this:

FROM `bq_trusted`.MATERIAL;   

with the {"v":{"f":[{"v":"5c82dfdef82cf17a0d61b2d8"},{"v":"PEDRO DANIEL DEL PUERTO ROBLES"},{"v":"5c82dfdef82cf17a0d61b2d6"},{"v":"119547"}]}} kind of format.

But when I change the hifen to the end, it solves the problem.

FROM `bq_trusted.MATERIAL`;