Sample Header Ad - 728x90

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