2
votes

Bigquery Web UI earlier used to display RECORD type in the dropdown but it has disappeared.

enter image description here

Can anyone tell me where did that option go & how to add a new col existing table that has TYPE record? the old trick of bq show & bq update Fails with following error message:

BigQuery error in update operation: Provided Schema does not match Table circular-gist-812:analytics_demo.user_notifications

1

1 Answers

3
votes

If you choose source format as CSV - you do not have record option Choose JSON and you will get it