René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"BigQuery feature: support determinism level for javascript UDFs","articleBody":"# Summary\r\n\r\nEnsure BigQuery client library supports the ability for a javascript UDF (exposed via the Routine resource) to communicate **determinism level**.\r\n\r\nThe functionality here is to allow users to inform the query engine about whether a function is deterministic or not, which can improve query performance.   Existing clients should already support the routines methods and resource type, so this should largely be a case of exposing a new field of the Routine and updating existing testing.\r\n\r\nFor integration testing, please note that only javascript UDFs allow determinism to be set; the backend will likely error when you try to set determinism for SQL UDFs or stored procedures.\r\n\r\n# References\r\n\r\nPublic REST reference includes information about the routine resource structure:\r\n\r\nhttps://cloud.google.com/bigquery/docs/reference/rest/v2/routines#resource:-routine\r\n\r\nHere's an example implementation that adds a new field to the Routine resource type in Go:\r\n\r\nhttps://github.com/googleapis/google-cloud-go/pull/3534\r\n\r\n","author":{"url":"https://github.com/shollyman","@type":"Person","name":"shollyman"},"datePublished":"2021-02-01T17:48:43.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/503/python-bigquery/issues/503"}