- Notifications
You must be signed in to change notification settings - Fork1.6k
BigQuery: Add Routines API.#8491
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.
Already on GitHub?Sign in to your account
Uh oh!
There was an error while loading.Please reload this page.
Conversation
Adds support for managing permanent functions in BigQuery, suchas scalar UDFs and stored procedures. At present, onlyscalar UDF functionality is available.Routines are registered as resources inside of datasets, andallow expected CRUD operations. Currently, routines do notsupport partial updates.See:https://cloud.google.com/bigquery/docs/reference/rest/v2/routines
shollyman left a comment
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others.Learn more.
One thing I'm not seeing in here is the ddlTargetRoutine in querystats for query jobs. Other than that, it looks like good coverage and samples.
| ) | ||
| returnModel.from_api_repr(api_response) | ||
| defupdate_routine(self,routine,fields,retry=DEFAULT_RETRY): |
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others.Learn more.
Should we have something in the docstring about partial update support b/134928435?
| @property | ||
| defimported_libraries(self): | ||
| """List[str]: The path of the imported JavaScript libraries. |
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others.Learn more.
We should be clearer that this is a set of GCS paths e.g. gs://my-bucket/path/to/lib1.js, not js import/require statements.
Adds support for managing permanent functions in BigQuery, such
as scalar UDFs and stored procedures. At present, only
scalar UDF functionality is available.
Routines are registered as resources inside of datasets, and
allow expected CRUD operations. Currently, routines do not
support partial updates.
See:https://cloud.google.com/bigquery/docs/reference/rest/v2/routines