So forgive my ignorance, but I can't seem to work this out. I want to create a "table" in BigQuery, from an API call. I am thinking https://developer.companieshouse.gov.uk/api/docs/search/companies/companysearch.html#here I want to easily query the Companies House API, without writing oodles…
My sample data is in json format and looks like: { "metadata": { "action": "insert", "type": "export", "version": 1, "timestamp": "2018-11-23T09:17:59.048-08:00" }, "data": { "attr1": 61, "day": "2018-11-22", "pin": "2C49956", "CDP": 0, "DP": 0, "VD": 0, "seo": 0, "dir": 0,…
I'm getting this following error when trying to delete records from a table created through GCP Console and updated with GCP BigQuery Node.js table insert function. UPDATE or DELETE DML statements are not supported over table stackdriver-360-150317:my_dataset.users with streaming buffer…