Does the BigQuery API offer a way to retrieve info on scheduled queries?
0
votes
1
answer
59
views
Using the BigQuery C# API, I can retrieve a list of job IDs :
BigQueryClient _client = BigQueryClient.Create(...);
...
foreach (var page in _client.ListJobs(projectId).AsRawResponses())
if (page.Jobs != null) // This does happen occasionally
foreach (var job in page.Jobs)
yield return job.Id;
This seems to give me all jobs ever run (or at least within some significant time horizon; it's tens of thousands of records). Still, I'd like to get the details for some jobs and see if I'm at least on the right track. I can retrieve a
BigQueryJob
object using BigQueryClient.GetJob()
(there's no C# doc, but the Java sample code is similar ), but the information returned is very limited: current state, any errors encountered, some basic statistics, etc. There's nothing about schedules.
Is there a separate command to retrieve details on scheduled queries? I can't find any such methods in the client.
Asked by Jon of All Trades
(5987 rep)
Sep 13, 2023, 03:16 PM