![[Google Cloud Documentation]](https://www.gstatic.com/devrel-devsite/prod/v0f3a5b8b76e4a120372a69044e02756e703b6140f9f1812c6e4a0407b19864b7/clouddocs/images/lockup_full_color.svg){kind=link}
![[]](https://docs.cloud.google.com/_static/clouddocs/images/icons/categories/devops-color.svg){kind=link}
Creates a new routine in the dataset.
Arguments
| Parameters | |
|---|---|
datasetId |
Required. Dataset ID of the new routine
|
projectId |
Required. Project ID of the new routine
|
body |
Required.
|
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 Routine.
Subworkflow snippet
Some fields might be optional or required. To identify required fields, refer to the API documentation.
YAML
- insert: call: googleapis.bigquery.v2.routines.insert args: datasetId: ... projectId: ... body: arguments: ... definitionBody: ... description: ... determinismLevel: ... importedLibraries: ... language: ... remoteFunctionOptions: connection: ... endpoint: ... maxBatchingRows: ... userDefinedContext: ... returnTableType: columns: ... returnType: arrayElementType: ... structType: fields: ... typeKind: ... routineReference: datasetId: ... projectId: ... routineId: ... routineType: ... sparkOptions: archiveUris: ... connection: ... containerImage: ... fileUris: ... jarUris: ... mainFileUri: ... properties: ... pyFileUris: ... runtimeVersion: ... strictMode: ... result: insertResult
JSON
[ { "insert": { "call": "googleapis.bigquery.v2.routines.insert", "args": { "datasetId": "...", "projectId": "...", "body": { "arguments": "...", "definitionBody": "...", "description": "...", "determinismLevel": "...", "importedLibraries": "...", "language": "...", "remoteFunctionOptions": { "connection": "...", "endpoint": "...", "maxBatchingRows": "...", "userDefinedContext": "..." }, "returnTableType": { "columns": "..." }, "returnType": { "arrayElementType": "...", "structType": { "fields": "..." }, "typeKind": "..." }, "routineReference": { "datasetId": "...", "projectId": "...", "routineId": "..." }, "routineType": "...", "sparkOptions": { "archiveUris": "...", "connection": "...", "containerImage": "...", "fileUris": "...", "jarUris": "...", "mainFileUri": "...", "properties": "...", "pyFileUris": "...", "runtimeVersion": "..." }, "strictMode": "..." } }, "result": "insertResult" } } ]