Method: googleapis.bigquery.v2.routines.insert
Stay organized with collections
Save and categorize content based on your preferences.
Creates a new routine in the dataset.
Arguments
Parameters |
datasetId |
string
Required. Dataset ID of the new routine
|
projectId |
string
Required. Project ID of the new routine
|
body |
object (Routine)
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"
}
}
]
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-28 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-28 UTC."],[],[],null,["# Method: googleapis.bigquery.v2.routines.insert\n\nCreates a new routine in the dataset.\n\nArguments\n---------\n\nRaised exceptions\n-----------------\n\nResponse\n--------\n\nIf successful, the response contains an instance of [`Routine`](/workflows/docs/reference/googleapis/bigquery/v2/Overview#Routine).\n\nSubworkflow snippet\n-------------------\n\nSome fields might be optional or required.\nTo identify required fields, refer to the [API documentation](https://cloud.google.com/bigquery/docs/reference/rest/v2/routines/insert). \n\n### YAML\n\n```yaml\n- insert:\n call: googleapis.bigquery.v2.routines.insert\n args:\n datasetId: ...\n projectId: ...\n body:\n arguments: ...\n definitionBody: ...\n description: ...\n determinismLevel: ...\n importedLibraries: ...\n language: ...\n remoteFunctionOptions:\n connection: ...\n endpoint: ...\n maxBatchingRows: ...\n userDefinedContext: ...\n returnTableType:\n columns: ...\n returnType:\n arrayElementType: ...\n structType:\n fields: ...\n typeKind: ...\n routineReference:\n datasetId: ...\n projectId: ...\n routineId: ...\n routineType: ...\n sparkOptions:\n archiveUris: ...\n connection: ...\n containerImage: ...\n fileUris: ...\n jarUris: ...\n mainFileUri: ...\n properties: ...\n pyFileUris: ...\n runtimeVersion: ...\n strictMode: ...\n result: insertResult\n```\n\n### JSON\n\n```json\n[\n {\n \"insert\": {\n \"call\": \"googleapis.bigquery.v2.routines.insert\",\n \"args\": {\n \"datasetId\": \"...\",\n \"projectId\": \"...\",\n \"body\": {\n \"arguments\": \"...\",\n \"definitionBody\": \"...\",\n \"description\": \"...\",\n \"determinismLevel\": \"...\",\n \"importedLibraries\": \"...\",\n \"language\": \"...\",\n \"remoteFunctionOptions\": {\n \"connection\": \"...\",\n \"endpoint\": \"...\",\n \"maxBatchingRows\": \"...\",\n \"userDefinedContext\": \"...\"\n },\n \"returnTableType\": {\n \"columns\": \"...\"\n },\n \"returnType\": {\n \"arrayElementType\": \"...\",\n \"structType\": {\n \"fields\": \"...\"\n },\n \"typeKind\": \"...\"\n },\n \"routineReference\": {\n \"datasetId\": \"...\",\n \"projectId\": \"...\",\n \"routineId\": \"...\"\n },\n \"routineType\": \"...\",\n \"sparkOptions\": {\n \"archiveUris\": \"...\",\n \"connection\": \"...\",\n \"containerImage\": \"...\",\n \"fileUris\": \"...\",\n \"jarUris\": \"...\",\n \"mainFileUri\": \"...\",\n \"properties\": \"...\",\n \"pyFileUris\": \"...\",\n \"runtimeVersion\": \"...\"\n },\n \"strictMode\": \"...\"\n }\n },\n \"result\": \"insertResult\"\n }\n }\n]\n```"]]