docs: update generated docs (#981)
diff --git a/docs/dyn/bigquery_v2.routines.html b/docs/dyn/bigquery_v2.routines.html
index e45766f..04e89fa 100644
--- a/docs/dyn/bigquery_v2.routines.html
+++ b/docs/dyn/bigquery_v2.routines.html
@@ -84,7 +84,7 @@
<code><a href="#insert">insert(projectId, datasetId, body=None)</a></code></p>
<p class="firstline">Creates a new routine in the dataset.</p>
<p class="toc_element">
- <code><a href="#list">list(projectId, datasetId, pageToken=None, maxResults=None, readMask=None, filter=None)</a></code></p>
+ <code><a href="#list">list(projectId, datasetId, readMask=None, filter=None, pageToken=None, maxResults=None)</a></code></p>
<p class="firstline">Lists all routines in the specified dataset. Requires the READER dataset</p>
<p class="toc_element">
<code><a href="#list_next">list_next(previous_request, previous_response)</a></code></p>
@@ -119,12 +119,43 @@
An object of the form:
{ # A user-defined function or a stored procedure.
+ "definitionBody": "A String", # Required. The body of the routine.
+ #
+ # For functions, this is the expression in the AS clause.
+ #
+ # If language=SQL, it is the substring inside (but excluding) the
+ # parentheses. For example, for the function created with the following
+ # statement:
+ #
+ # `CREATE FUNCTION JoinLines(x string, y string) as (concat(x, "\n", y))`
+ #
+ # The definition_body is `concat(x, "\n", y)` (\n is not replaced with
+ # linebreak).
+ #
+ # If language=JAVASCRIPT, it is the evaluated string in the AS clause.
+ # For example, for the function created with the following statement:
+ #
+ # `CREATE FUNCTION f() RETURNS STRING LANGUAGE js AS 'return "\n";\n'`
+ #
+ # The definition_body is
+ #
+ # `return "\n";\n`
+ #
+ # Note that both \n are replaced with linebreaks.
+ "routineReference": { # Required. Reference describing the ID of this routine.
+ "projectId": "A String", # [Required] The ID of the project containing this routine.
+ "datasetId": "A String", # [Required] The ID of the dataset containing this routine.
+ "routineId": "A String", # [Required] The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
+ },
+ "determinismLevel": "A String", # Optional. [Experimental] The determinism level of the JavaScript UDF if defined.
+ "language": "A String", # Optional. Defaults to "SQL".
+ "description": "A String", # Optional. [Experimental] The description of the routine if defined.
+ "etag": "A String", # Output only. A hash of this resource.
+ "routineType": "A String", # Required. The type of routine.
+ "creationTime": "A String", # Output only. The time when this routine was created, in milliseconds since
+ # the epoch.
"arguments": [ # Optional.
{ # Input/output argument of a function or a stored procedure.
- "name": "A String", # Optional. The name of this argument. Can be absent for function return argument.
- "argumentKind": "A String", # Optional. Defaults to FIXED_TYPE.
- "mode": "A String", # Optional. Specifies whether the argument is input or output.
- # Can be set for procedures only.
"dataType": { # The type of a variable, e.g., a function argument. # Required unless argument_kind = ANY_TYPE.
# Examples:
# INT64: {type_kind="INT64"}
@@ -135,7 +166,6 @@
# {name="x", type={type_kind="STRING"}},
# {name="y", type={type_kind="ARRAY", array_element_type="DATE"}}
# ]}}
- "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
"typeKind": "A String", # Required. The top level type of this field.
# Can be any standard SQL data type (e.g., "INT64", "DATE", "ARRAY").
"structType": { # The fields of this struct, in order, if type_kind = "STRUCT".
@@ -143,7 +173,12 @@
# Object with schema name: StandardSqlField
],
},
+ "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
},
+ "name": "A String", # Optional. The name of this argument. Can be absent for function return argument.
+ "argumentKind": "A String", # Optional. Defaults to FIXED_TYPE.
+ "mode": "A String", # Optional. Specifies whether the argument is input or output.
+ # Can be set for procedures only.
},
],
"importedLibraries": [ # Optional. If language = "JAVASCRIPT", this field stores the path of the
@@ -181,7 +216,6 @@
# {name="x", type={type_kind="STRING"}},
# {name="y", type={type_kind="ARRAY", array_element_type="DATE"}}
# ]}}
- "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
"typeKind": "A String", # Required. The top level type of this field.
# Can be any standard SQL data type (e.g., "INT64", "DATE", "ARRAY").
"structType": { # The fields of this struct, in order, if type_kind = "STRUCT".
@@ -189,43 +223,10 @@
# Object with schema name: StandardSqlField
],
},
+ "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
},
- "language": "A String", # Optional. Defaults to "SQL".
"lastModifiedTime": "A String", # Output only. The time when this routine was last modified, in milliseconds
# since the epoch.
- "description": "A String", # Optional. [Experimental] The description of the routine if defined.
- "etag": "A String", # Output only. A hash of this resource.
- "definitionBody": "A String", # Required. The body of the routine.
- #
- # For functions, this is the expression in the AS clause.
- #
- # If language=SQL, it is the substring inside (but excluding) the
- # parentheses. For example, for the function created with the following
- # statement:
- #
- # `CREATE FUNCTION JoinLines(x string, y string) as (concat(x, "\n", y))`
- #
- # The definition_body is `concat(x, "\n", y)` (\n is not replaced with
- # linebreak).
- #
- # If language=JAVASCRIPT, it is the evaluated string in the AS clause.
- # For example, for the function created with the following statement:
- #
- # `CREATE FUNCTION f() RETURNS STRING LANGUAGE js AS 'return "\n";\n'`
- #
- # The definition_body is
- #
- # `return "\n";\n`
- #
- # Note that both \n are replaced with linebreaks.
- "creationTime": "A String", # Output only. The time when this routine was created, in milliseconds since
- # the epoch.
- "routineType": "A String", # Required. The type of routine.
- "routineReference": { # Required. Reference describing the ID of this routine.
- "projectId": "A String", # [Required] The ID of the project containing this routine.
- "datasetId": "A String", # [Required] The ID of the dataset containing this routine.
- "routineId": "A String", # [Required] The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
- },
}</pre>
</div>
@@ -240,12 +241,43 @@
The object takes the form of:
{ # A user-defined function or a stored procedure.
+ "definitionBody": "A String", # Required. The body of the routine.
+ #
+ # For functions, this is the expression in the AS clause.
+ #
+ # If language=SQL, it is the substring inside (but excluding) the
+ # parentheses. For example, for the function created with the following
+ # statement:
+ #
+ # `CREATE FUNCTION JoinLines(x string, y string) as (concat(x, "\n", y))`
+ #
+ # The definition_body is `concat(x, "\n", y)` (\n is not replaced with
+ # linebreak).
+ #
+ # If language=JAVASCRIPT, it is the evaluated string in the AS clause.
+ # For example, for the function created with the following statement:
+ #
+ # `CREATE FUNCTION f() RETURNS STRING LANGUAGE js AS 'return "\n";\n'`
+ #
+ # The definition_body is
+ #
+ # `return "\n";\n`
+ #
+ # Note that both \n are replaced with linebreaks.
+ "routineReference": { # Required. Reference describing the ID of this routine.
+ "projectId": "A String", # [Required] The ID of the project containing this routine.
+ "datasetId": "A String", # [Required] The ID of the dataset containing this routine.
+ "routineId": "A String", # [Required] The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
+ },
+ "determinismLevel": "A String", # Optional. [Experimental] The determinism level of the JavaScript UDF if defined.
+ "language": "A String", # Optional. Defaults to "SQL".
+ "description": "A String", # Optional. [Experimental] The description of the routine if defined.
+ "etag": "A String", # Output only. A hash of this resource.
+ "routineType": "A String", # Required. The type of routine.
+ "creationTime": "A String", # Output only. The time when this routine was created, in milliseconds since
+ # the epoch.
"arguments": [ # Optional.
{ # Input/output argument of a function or a stored procedure.
- "name": "A String", # Optional. The name of this argument. Can be absent for function return argument.
- "argumentKind": "A String", # Optional. Defaults to FIXED_TYPE.
- "mode": "A String", # Optional. Specifies whether the argument is input or output.
- # Can be set for procedures only.
"dataType": { # The type of a variable, e.g., a function argument. # Required unless argument_kind = ANY_TYPE.
# Examples:
# INT64: {type_kind="INT64"}
@@ -256,7 +288,6 @@
# {name="x", type={type_kind="STRING"}},
# {name="y", type={type_kind="ARRAY", array_element_type="DATE"}}
# ]}}
- "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
"typeKind": "A String", # Required. The top level type of this field.
# Can be any standard SQL data type (e.g., "INT64", "DATE", "ARRAY").
"structType": { # The fields of this struct, in order, if type_kind = "STRUCT".
@@ -264,7 +295,12 @@
# Object with schema name: StandardSqlField
],
},
+ "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
},
+ "name": "A String", # Optional. The name of this argument. Can be absent for function return argument.
+ "argumentKind": "A String", # Optional. Defaults to FIXED_TYPE.
+ "mode": "A String", # Optional. Specifies whether the argument is input or output.
+ # Can be set for procedures only.
},
],
"importedLibraries": [ # Optional. If language = "JAVASCRIPT", this field stores the path of the
@@ -302,7 +338,6 @@
# {name="x", type={type_kind="STRING"}},
# {name="y", type={type_kind="ARRAY", array_element_type="DATE"}}
# ]}}
- "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
"typeKind": "A String", # Required. The top level type of this field.
# Can be any standard SQL data type (e.g., "INT64", "DATE", "ARRAY").
"structType": { # The fields of this struct, in order, if type_kind = "STRUCT".
@@ -310,43 +345,10 @@
# Object with schema name: StandardSqlField
],
},
+ "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
},
- "language": "A String", # Optional. Defaults to "SQL".
"lastModifiedTime": "A String", # Output only. The time when this routine was last modified, in milliseconds
# since the epoch.
- "description": "A String", # Optional. [Experimental] The description of the routine if defined.
- "etag": "A String", # Output only. A hash of this resource.
- "definitionBody": "A String", # Required. The body of the routine.
- #
- # For functions, this is the expression in the AS clause.
- #
- # If language=SQL, it is the substring inside (but excluding) the
- # parentheses. For example, for the function created with the following
- # statement:
- #
- # `CREATE FUNCTION JoinLines(x string, y string) as (concat(x, "\n", y))`
- #
- # The definition_body is `concat(x, "\n", y)` (\n is not replaced with
- # linebreak).
- #
- # If language=JAVASCRIPT, it is the evaluated string in the AS clause.
- # For example, for the function created with the following statement:
- #
- # `CREATE FUNCTION f() RETURNS STRING LANGUAGE js AS 'return "\n";\n'`
- #
- # The definition_body is
- #
- # `return "\n";\n`
- #
- # Note that both \n are replaced with linebreaks.
- "creationTime": "A String", # Output only. The time when this routine was created, in milliseconds since
- # the epoch.
- "routineType": "A String", # Required. The type of routine.
- "routineReference": { # Required. Reference describing the ID of this routine.
- "projectId": "A String", # [Required] The ID of the project containing this routine.
- "datasetId": "A String", # [Required] The ID of the dataset containing this routine.
- "routineId": "A String", # [Required] The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
- },
}
@@ -354,12 +356,43 @@
An object of the form:
{ # A user-defined function or a stored procedure.
+ "definitionBody": "A String", # Required. The body of the routine.
+ #
+ # For functions, this is the expression in the AS clause.
+ #
+ # If language=SQL, it is the substring inside (but excluding) the
+ # parentheses. For example, for the function created with the following
+ # statement:
+ #
+ # `CREATE FUNCTION JoinLines(x string, y string) as (concat(x, "\n", y))`
+ #
+ # The definition_body is `concat(x, "\n", y)` (\n is not replaced with
+ # linebreak).
+ #
+ # If language=JAVASCRIPT, it is the evaluated string in the AS clause.
+ # For example, for the function created with the following statement:
+ #
+ # `CREATE FUNCTION f() RETURNS STRING LANGUAGE js AS 'return "\n";\n'`
+ #
+ # The definition_body is
+ #
+ # `return "\n";\n`
+ #
+ # Note that both \n are replaced with linebreaks.
+ "routineReference": { # Required. Reference describing the ID of this routine.
+ "projectId": "A String", # [Required] The ID of the project containing this routine.
+ "datasetId": "A String", # [Required] The ID of the dataset containing this routine.
+ "routineId": "A String", # [Required] The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
+ },
+ "determinismLevel": "A String", # Optional. [Experimental] The determinism level of the JavaScript UDF if defined.
+ "language": "A String", # Optional. Defaults to "SQL".
+ "description": "A String", # Optional. [Experimental] The description of the routine if defined.
+ "etag": "A String", # Output only. A hash of this resource.
+ "routineType": "A String", # Required. The type of routine.
+ "creationTime": "A String", # Output only. The time when this routine was created, in milliseconds since
+ # the epoch.
"arguments": [ # Optional.
{ # Input/output argument of a function or a stored procedure.
- "name": "A String", # Optional. The name of this argument. Can be absent for function return argument.
- "argumentKind": "A String", # Optional. Defaults to FIXED_TYPE.
- "mode": "A String", # Optional. Specifies whether the argument is input or output.
- # Can be set for procedures only.
"dataType": { # The type of a variable, e.g., a function argument. # Required unless argument_kind = ANY_TYPE.
# Examples:
# INT64: {type_kind="INT64"}
@@ -370,7 +403,6 @@
# {name="x", type={type_kind="STRING"}},
# {name="y", type={type_kind="ARRAY", array_element_type="DATE"}}
# ]}}
- "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
"typeKind": "A String", # Required. The top level type of this field.
# Can be any standard SQL data type (e.g., "INT64", "DATE", "ARRAY").
"structType": { # The fields of this struct, in order, if type_kind = "STRUCT".
@@ -378,7 +410,12 @@
# Object with schema name: StandardSqlField
],
},
+ "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
},
+ "name": "A String", # Optional. The name of this argument. Can be absent for function return argument.
+ "argumentKind": "A String", # Optional. Defaults to FIXED_TYPE.
+ "mode": "A String", # Optional. Specifies whether the argument is input or output.
+ # Can be set for procedures only.
},
],
"importedLibraries": [ # Optional. If language = "JAVASCRIPT", this field stores the path of the
@@ -416,7 +453,6 @@
# {name="x", type={type_kind="STRING"}},
# {name="y", type={type_kind="ARRAY", array_element_type="DATE"}}
# ]}}
- "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
"typeKind": "A String", # Required. The top level type of this field.
# Can be any standard SQL data type (e.g., "INT64", "DATE", "ARRAY").
"structType": { # The fields of this struct, in order, if type_kind = "STRUCT".
@@ -424,58 +460,21 @@
# Object with schema name: StandardSqlField
],
},
+ "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
},
- "language": "A String", # Optional. Defaults to "SQL".
"lastModifiedTime": "A String", # Output only. The time when this routine was last modified, in milliseconds
# since the epoch.
- "description": "A String", # Optional. [Experimental] The description of the routine if defined.
- "etag": "A String", # Output only. A hash of this resource.
- "definitionBody": "A String", # Required. The body of the routine.
- #
- # For functions, this is the expression in the AS clause.
- #
- # If language=SQL, it is the substring inside (but excluding) the
- # parentheses. For example, for the function created with the following
- # statement:
- #
- # `CREATE FUNCTION JoinLines(x string, y string) as (concat(x, "\n", y))`
- #
- # The definition_body is `concat(x, "\n", y)` (\n is not replaced with
- # linebreak).
- #
- # If language=JAVASCRIPT, it is the evaluated string in the AS clause.
- # For example, for the function created with the following statement:
- #
- # `CREATE FUNCTION f() RETURNS STRING LANGUAGE js AS 'return "\n";\n'`
- #
- # The definition_body is
- #
- # `return "\n";\n`
- #
- # Note that both \n are replaced with linebreaks.
- "creationTime": "A String", # Output only. The time when this routine was created, in milliseconds since
- # the epoch.
- "routineType": "A String", # Required. The type of routine.
- "routineReference": { # Required. Reference describing the ID of this routine.
- "projectId": "A String", # [Required] The ID of the project containing this routine.
- "datasetId": "A String", # [Required] The ID of the dataset containing this routine.
- "routineId": "A String", # [Required] The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
- },
}</pre>
</div>
<div class="method">
- <code class="details" id="list">list(projectId, datasetId, pageToken=None, maxResults=None, readMask=None, filter=None)</code>
+ <code class="details" id="list">list(projectId, datasetId, readMask=None, filter=None, pageToken=None, maxResults=None)</code>
<pre>Lists all routines in the specified dataset. Requires the READER dataset
role.
Args:
projectId: string, Required. Project ID of the routines to list (required)
datasetId: string, Required. Dataset ID of the routines to list (required)
- pageToken: string, Page token, returned by a previous call, to request the next page of
-results
- maxResults: integer, The maximum number of results to return in a single response page.
-Leverage the page tokens to iterate through the entire collection.
readMask: string, 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:
@@ -485,6 +484,10 @@
The current supported form is either "routine_type:<RoutineType>" or
"routineType:<RoutineType>", where <RoutineType> is a RoutineType enum.
Example: "routineType:SCALAR_FUNCTION".
+ pageToken: string, Page token, returned by a previous call, to request the next page of
+results
+ maxResults: integer, The maximum number of results to return in a single response page.
+Leverage the page tokens to iterate through the entire collection.
Returns:
An object of the form:
@@ -495,12 +498,43 @@
# etag, project_id, dataset_id, routine_id, routine_type, creation_time,
# last_modified_time, and language.
{ # A user-defined function or a stored procedure.
+ "definitionBody": "A String", # Required. The body of the routine.
+ #
+ # For functions, this is the expression in the AS clause.
+ #
+ # If language=SQL, it is the substring inside (but excluding) the
+ # parentheses. For example, for the function created with the following
+ # statement:
+ #
+ # `CREATE FUNCTION JoinLines(x string, y string) as (concat(x, "\n", y))`
+ #
+ # The definition_body is `concat(x, "\n", y)` (\n is not replaced with
+ # linebreak).
+ #
+ # If language=JAVASCRIPT, it is the evaluated string in the AS clause.
+ # For example, for the function created with the following statement:
+ #
+ # `CREATE FUNCTION f() RETURNS STRING LANGUAGE js AS 'return "\n";\n'`
+ #
+ # The definition_body is
+ #
+ # `return "\n";\n`
+ #
+ # Note that both \n are replaced with linebreaks.
+ "routineReference": { # Required. Reference describing the ID of this routine.
+ "projectId": "A String", # [Required] The ID of the project containing this routine.
+ "datasetId": "A String", # [Required] The ID of the dataset containing this routine.
+ "routineId": "A String", # [Required] The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
+ },
+ "determinismLevel": "A String", # Optional. [Experimental] The determinism level of the JavaScript UDF if defined.
+ "language": "A String", # Optional. Defaults to "SQL".
+ "description": "A String", # Optional. [Experimental] The description of the routine if defined.
+ "etag": "A String", # Output only. A hash of this resource.
+ "routineType": "A String", # Required. The type of routine.
+ "creationTime": "A String", # Output only. The time when this routine was created, in milliseconds since
+ # the epoch.
"arguments": [ # Optional.
{ # Input/output argument of a function or a stored procedure.
- "name": "A String", # Optional. The name of this argument. Can be absent for function return argument.
- "argumentKind": "A String", # Optional. Defaults to FIXED_TYPE.
- "mode": "A String", # Optional. Specifies whether the argument is input or output.
- # Can be set for procedures only.
"dataType": { # The type of a variable, e.g., a function argument. # Required unless argument_kind = ANY_TYPE.
# Examples:
# INT64: {type_kind="INT64"}
@@ -511,7 +545,6 @@
# {name="x", type={type_kind="STRING"}},
# {name="y", type={type_kind="ARRAY", array_element_type="DATE"}}
# ]}}
- "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
"typeKind": "A String", # Required. The top level type of this field.
# Can be any standard SQL data type (e.g., "INT64", "DATE", "ARRAY").
"structType": { # The fields of this struct, in order, if type_kind = "STRUCT".
@@ -519,7 +552,12 @@
# Object with schema name: StandardSqlField
],
},
+ "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
},
+ "name": "A String", # Optional. The name of this argument. Can be absent for function return argument.
+ "argumentKind": "A String", # Optional. Defaults to FIXED_TYPE.
+ "mode": "A String", # Optional. Specifies whether the argument is input or output.
+ # Can be set for procedures only.
},
],
"importedLibraries": [ # Optional. If language = "JAVASCRIPT", this field stores the path of the
@@ -557,7 +595,6 @@
# {name="x", type={type_kind="STRING"}},
# {name="y", type={type_kind="ARRAY", array_element_type="DATE"}}
# ]}}
- "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
"typeKind": "A String", # Required. The top level type of this field.
# Can be any standard SQL data type (e.g., "INT64", "DATE", "ARRAY").
"structType": { # The fields of this struct, in order, if type_kind = "STRUCT".
@@ -565,43 +602,10 @@
# Object with schema name: StandardSqlField
],
},
+ "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
},
- "language": "A String", # Optional. Defaults to "SQL".
"lastModifiedTime": "A String", # Output only. The time when this routine was last modified, in milliseconds
# since the epoch.
- "description": "A String", # Optional. [Experimental] The description of the routine if defined.
- "etag": "A String", # Output only. A hash of this resource.
- "definitionBody": "A String", # Required. The body of the routine.
- #
- # For functions, this is the expression in the AS clause.
- #
- # If language=SQL, it is the substring inside (but excluding) the
- # parentheses. For example, for the function created with the following
- # statement:
- #
- # `CREATE FUNCTION JoinLines(x string, y string) as (concat(x, "\n", y))`
- #
- # The definition_body is `concat(x, "\n", y)` (\n is not replaced with
- # linebreak).
- #
- # If language=JAVASCRIPT, it is the evaluated string in the AS clause.
- # For example, for the function created with the following statement:
- #
- # `CREATE FUNCTION f() RETURNS STRING LANGUAGE js AS 'return "\n";\n'`
- #
- # The definition_body is
- #
- # `return "\n";\n`
- #
- # Note that both \n are replaced with linebreaks.
- "creationTime": "A String", # Output only. The time when this routine was created, in milliseconds since
- # the epoch.
- "routineType": "A String", # Required. The type of routine.
- "routineReference": { # Required. Reference describing the ID of this routine.
- "projectId": "A String", # [Required] The ID of the project containing this routine.
- "datasetId": "A String", # [Required] The ID of the dataset containing this routine.
- "routineId": "A String", # [Required] The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
- },
},
],
"nextPageToken": "A String", # A token to request the next page of results.
@@ -635,12 +639,43 @@
The object takes the form of:
{ # A user-defined function or a stored procedure.
+ "definitionBody": "A String", # Required. The body of the routine.
+ #
+ # For functions, this is the expression in the AS clause.
+ #
+ # If language=SQL, it is the substring inside (but excluding) the
+ # parentheses. For example, for the function created with the following
+ # statement:
+ #
+ # `CREATE FUNCTION JoinLines(x string, y string) as (concat(x, "\n", y))`
+ #
+ # The definition_body is `concat(x, "\n", y)` (\n is not replaced with
+ # linebreak).
+ #
+ # If language=JAVASCRIPT, it is the evaluated string in the AS clause.
+ # For example, for the function created with the following statement:
+ #
+ # `CREATE FUNCTION f() RETURNS STRING LANGUAGE js AS 'return "\n";\n'`
+ #
+ # The definition_body is
+ #
+ # `return "\n";\n`
+ #
+ # Note that both \n are replaced with linebreaks.
+ "routineReference": { # Required. Reference describing the ID of this routine.
+ "projectId": "A String", # [Required] The ID of the project containing this routine.
+ "datasetId": "A String", # [Required] The ID of the dataset containing this routine.
+ "routineId": "A String", # [Required] The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
+ },
+ "determinismLevel": "A String", # Optional. [Experimental] The determinism level of the JavaScript UDF if defined.
+ "language": "A String", # Optional. Defaults to "SQL".
+ "description": "A String", # Optional. [Experimental] The description of the routine if defined.
+ "etag": "A String", # Output only. A hash of this resource.
+ "routineType": "A String", # Required. The type of routine.
+ "creationTime": "A String", # Output only. The time when this routine was created, in milliseconds since
+ # the epoch.
"arguments": [ # Optional.
{ # Input/output argument of a function or a stored procedure.
- "name": "A String", # Optional. The name of this argument. Can be absent for function return argument.
- "argumentKind": "A String", # Optional. Defaults to FIXED_TYPE.
- "mode": "A String", # Optional. Specifies whether the argument is input or output.
- # Can be set for procedures only.
"dataType": { # The type of a variable, e.g., a function argument. # Required unless argument_kind = ANY_TYPE.
# Examples:
# INT64: {type_kind="INT64"}
@@ -651,7 +686,6 @@
# {name="x", type={type_kind="STRING"}},
# {name="y", type={type_kind="ARRAY", array_element_type="DATE"}}
# ]}}
- "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
"typeKind": "A String", # Required. The top level type of this field.
# Can be any standard SQL data type (e.g., "INT64", "DATE", "ARRAY").
"structType": { # The fields of this struct, in order, if type_kind = "STRUCT".
@@ -659,7 +693,12 @@
# Object with schema name: StandardSqlField
],
},
+ "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
},
+ "name": "A String", # Optional. The name of this argument. Can be absent for function return argument.
+ "argumentKind": "A String", # Optional. Defaults to FIXED_TYPE.
+ "mode": "A String", # Optional. Specifies whether the argument is input or output.
+ # Can be set for procedures only.
},
],
"importedLibraries": [ # Optional. If language = "JAVASCRIPT", this field stores the path of the
@@ -697,7 +736,6 @@
# {name="x", type={type_kind="STRING"}},
# {name="y", type={type_kind="ARRAY", array_element_type="DATE"}}
# ]}}
- "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
"typeKind": "A String", # Required. The top level type of this field.
# Can be any standard SQL data type (e.g., "INT64", "DATE", "ARRAY").
"structType": { # The fields of this struct, in order, if type_kind = "STRUCT".
@@ -705,43 +743,10 @@
# Object with schema name: StandardSqlField
],
},
+ "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
},
- "language": "A String", # Optional. Defaults to "SQL".
"lastModifiedTime": "A String", # Output only. The time when this routine was last modified, in milliseconds
# since the epoch.
- "description": "A String", # Optional. [Experimental] The description of the routine if defined.
- "etag": "A String", # Output only. A hash of this resource.
- "definitionBody": "A String", # Required. The body of the routine.
- #
- # For functions, this is the expression in the AS clause.
- #
- # If language=SQL, it is the substring inside (but excluding) the
- # parentheses. For example, for the function created with the following
- # statement:
- #
- # `CREATE FUNCTION JoinLines(x string, y string) as (concat(x, "\n", y))`
- #
- # The definition_body is `concat(x, "\n", y)` (\n is not replaced with
- # linebreak).
- #
- # If language=JAVASCRIPT, it is the evaluated string in the AS clause.
- # For example, for the function created with the following statement:
- #
- # `CREATE FUNCTION f() RETURNS STRING LANGUAGE js AS 'return "\n";\n'`
- #
- # The definition_body is
- #
- # `return "\n";\n`
- #
- # Note that both \n are replaced with linebreaks.
- "creationTime": "A String", # Output only. The time when this routine was created, in milliseconds since
- # the epoch.
- "routineType": "A String", # Required. The type of routine.
- "routineReference": { # Required. Reference describing the ID of this routine.
- "projectId": "A String", # [Required] The ID of the project containing this routine.
- "datasetId": "A String", # [Required] The ID of the dataset containing this routine.
- "routineId": "A String", # [Required] The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
- },
}
@@ -749,12 +754,43 @@
An object of the form:
{ # A user-defined function or a stored procedure.
+ "definitionBody": "A String", # Required. The body of the routine.
+ #
+ # For functions, this is the expression in the AS clause.
+ #
+ # If language=SQL, it is the substring inside (but excluding) the
+ # parentheses. For example, for the function created with the following
+ # statement:
+ #
+ # `CREATE FUNCTION JoinLines(x string, y string) as (concat(x, "\n", y))`
+ #
+ # The definition_body is `concat(x, "\n", y)` (\n is not replaced with
+ # linebreak).
+ #
+ # If language=JAVASCRIPT, it is the evaluated string in the AS clause.
+ # For example, for the function created with the following statement:
+ #
+ # `CREATE FUNCTION f() RETURNS STRING LANGUAGE js AS 'return "\n";\n'`
+ #
+ # The definition_body is
+ #
+ # `return "\n";\n`
+ #
+ # Note that both \n are replaced with linebreaks.
+ "routineReference": { # Required. Reference describing the ID of this routine.
+ "projectId": "A String", # [Required] The ID of the project containing this routine.
+ "datasetId": "A String", # [Required] The ID of the dataset containing this routine.
+ "routineId": "A String", # [Required] The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
+ },
+ "determinismLevel": "A String", # Optional. [Experimental] The determinism level of the JavaScript UDF if defined.
+ "language": "A String", # Optional. Defaults to "SQL".
+ "description": "A String", # Optional. [Experimental] The description of the routine if defined.
+ "etag": "A String", # Output only. A hash of this resource.
+ "routineType": "A String", # Required. The type of routine.
+ "creationTime": "A String", # Output only. The time when this routine was created, in milliseconds since
+ # the epoch.
"arguments": [ # Optional.
{ # Input/output argument of a function or a stored procedure.
- "name": "A String", # Optional. The name of this argument. Can be absent for function return argument.
- "argumentKind": "A String", # Optional. Defaults to FIXED_TYPE.
- "mode": "A String", # Optional. Specifies whether the argument is input or output.
- # Can be set for procedures only.
"dataType": { # The type of a variable, e.g., a function argument. # Required unless argument_kind = ANY_TYPE.
# Examples:
# INT64: {type_kind="INT64"}
@@ -765,7 +801,6 @@
# {name="x", type={type_kind="STRING"}},
# {name="y", type={type_kind="ARRAY", array_element_type="DATE"}}
# ]}}
- "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
"typeKind": "A String", # Required. The top level type of this field.
# Can be any standard SQL data type (e.g., "INT64", "DATE", "ARRAY").
"structType": { # The fields of this struct, in order, if type_kind = "STRUCT".
@@ -773,7 +808,12 @@
# Object with schema name: StandardSqlField
],
},
+ "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
},
+ "name": "A String", # Optional. The name of this argument. Can be absent for function return argument.
+ "argumentKind": "A String", # Optional. Defaults to FIXED_TYPE.
+ "mode": "A String", # Optional. Specifies whether the argument is input or output.
+ # Can be set for procedures only.
},
],
"importedLibraries": [ # Optional. If language = "JAVASCRIPT", this field stores the path of the
@@ -811,7 +851,6 @@
# {name="x", type={type_kind="STRING"}},
# {name="y", type={type_kind="ARRAY", array_element_type="DATE"}}
# ]}}
- "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
"typeKind": "A String", # Required. The top level type of this field.
# Can be any standard SQL data type (e.g., "INT64", "DATE", "ARRAY").
"structType": { # The fields of this struct, in order, if type_kind = "STRUCT".
@@ -819,43 +858,10 @@
# Object with schema name: StandardSqlField
],
},
+ "arrayElementType": # Object with schema name: StandardSqlDataType # The type of the array's elements, if type_kind = "ARRAY".
},
- "language": "A String", # Optional. Defaults to "SQL".
"lastModifiedTime": "A String", # Output only. The time when this routine was last modified, in milliseconds
# since the epoch.
- "description": "A String", # Optional. [Experimental] The description of the routine if defined.
- "etag": "A String", # Output only. A hash of this resource.
- "definitionBody": "A String", # Required. The body of the routine.
- #
- # For functions, this is the expression in the AS clause.
- #
- # If language=SQL, it is the substring inside (but excluding) the
- # parentheses. For example, for the function created with the following
- # statement:
- #
- # `CREATE FUNCTION JoinLines(x string, y string) as (concat(x, "\n", y))`
- #
- # The definition_body is `concat(x, "\n", y)` (\n is not replaced with
- # linebreak).
- #
- # If language=JAVASCRIPT, it is the evaluated string in the AS clause.
- # For example, for the function created with the following statement:
- #
- # `CREATE FUNCTION f() RETURNS STRING LANGUAGE js AS 'return "\n";\n'`
- #
- # The definition_body is
- #
- # `return "\n";\n`
- #
- # Note that both \n are replaced with linebreaks.
- "creationTime": "A String", # Output only. The time when this routine was created, in milliseconds since
- # the epoch.
- "routineType": "A String", # Required. The type of routine.
- "routineReference": { # Required. Reference describing the ID of this routine.
- "projectId": "A String", # [Required] The ID of the project containing this routine.
- "datasetId": "A String", # [Required] The ID of the dataset containing this routine.
- "routineId": "A String", # [Required] The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
- },
}</pre>
</div>