-
BigQuery API no longer working
Hello!
I have seen that in the last 2 weeks, all the calls using the BigQuery API stopped working. No matter which method you use, it always comes back with the error:
Missing args, datasets.list requires args: +projectId
[2] (.com_kx_bq.run)[3] (.com_kx_bq.datasets.list)
Notice the below script that used to be working
l bq.q_ .kurl.register (`oauth2; "*.googleapis.com"; ""; enlist[`access_token]!enlist getenv `GOOGLE_TOKEN) .com_kx_bq.cfg.default.projectId:"<ProjectId>" .com_kx_bq.datasets.list enlist[`projectId]!enlist "<ProjectId>" 'Missing args, datasets.list requires args: +projectId [2] (.com_kx_bq.run) [1] (.com_kx_bq.datasets.list)
It seems to me that the library no longer recognised the projectId args no matter if you add it or use the default ones. It always come back with the error Missing args, <method>requires args: +projectId
Has anyone else started experiencing similar issues?
-
2 Replies
-
Adding to the above. It is definitively an issue related to adding args in the run function. Executing a function that doesn’t require any args (i.e. list projects) still works:
q).com_kx_bq.projects.list[] kind | "bigquery#projectList" etag | "PXl7AcbMGzFMur/boIkUvA==" projects | +`kind`id`numericId`projectReference`friendlyName!(,"bigquery#pro.. totalItems| 1f
I have added the default projectId in the configuration but no luck when trying to run any simple query or list datasets for example:
.com_kx_bq.query "WITH AllTrades AS( SELECT * from project.dataset.demo)" 'Missing args, jobs.query requires args: +projectId [11] (.com_kx_bq.run) [10] (.com_kx_bq.queryRawResp)
-
Hi ,
Thank you for bringing this to our attention.
Our team are currently working on getting this up and running again.
We will update you as soon as we come to a solution.
Many thanks,
Megan
-
Thank you Megan!
FYI – the amazing support team has already given me a way forward. We just simply need to change the way we assign the default ProjectID as follows
.com_kx_bq.cfg.default[`$"+projectId"]:"<PROJECTID>"
And that’s pretty much it! Not sure if the docs will be updated or a new version of the library will be released, but for now this works well.
Log in to reply.