Lists all routines in the specified dataset. Requires the READER dataset role.
Arguments
Parameters | |
---|---|
datasetId |
Required. Dataset ID of the routines to list
|
projectId |
Required. Project ID of the routines to list
|
filter |
If set, then only the Routines matching this filter are returned. The current supported form is either "routine_type:" or "routineType:", where is a RoutineType enum. Example: "routineType:SCALAR_FUNCTION".
|
maxResults |
The maximum number of results to return in a single response page. Leverage the page tokens to iterate through the entire collection.
|
pageToken |
Page token, returned by a previous call, to request the next page of results
|
readMask |
If set, then only the Routine fields in the field mask, as well as project_id, dataset_id and routine_id, are returned in the response. If unset, then the following Routine fields are returned: etag, project_id, dataset_id, routine_id, routine_type, creation_time, last_modified_time, and language.
|
Raised exceptions
Exceptions | |
---|---|
ConnectionError |
In case of a network problem (such as DNS failure or refused connection). |
HttpError |
If the response status is >= 400 (excluding 429 and 503). |
TimeoutError |
If a long-running operation takes longer to finish than the specified timeout limit. |
TypeError |
If an operation or function receives an argument of the wrong type. |
ValueError |
If an operation or function receives an argument of the right type but an inappropriate value. For example, a negative timeout. |
Response
If successful, the response contains an instance of ListRoutinesResponse
.
Subworkflow snippet
Some fields might be optional or required. To identify required fields, refer to the API documentation.
YAML
- list: call: googleapis.bigquery.v2.routines.list args: datasetId: ... projectId: ... filter: ... maxResults: ... pageToken: ... readMask: ... result: listResult
JSON
[ { "list": { "call": "googleapis.bigquery.v2.routines.list", "args": { "datasetId": "...", "projectId": "...", "filter": "...", "maxResults": "...", "pageToken": "...", "readMask": "..." }, "result": "listResult" } } ]