ResultSetMetadata

JSON representation

Metadata about a ResultSet or PartialResultSet .

JSON representation
{ "rowType" : { object ( `StructType` ) } , "transaction" : { object ( `Transaction` ) } , "undeclaredParameters" : { object ( `StructType` ) } }

Fields

Fields
`rowType`	`object ( StructType )` Indicates the field names and types for the rows in the result set. For example, a SQL query like `"SELECT UserId, UserName FROM Users"` could return a `rowType` value like: `"fields": [ { "name": "UserId", "type": { "code": "INT64" } }, { "name": "UserName", "type": { "code": "STRING" } }, ]`
`transaction`	`object ( Transaction )` If the read or SQL query began a transaction as a side-effect, the information about the new transaction is yielded here.
`undeclaredParameters`	`object ( StructType )` A SQL query can be parameterized. In PLAN mode, these parameters can be undeclared. This indicates the field names and types for those undeclared parameters in the SQL query. For example, a SQL query like `"SELECT * FROM Users where UserId = @userId and UserName = @userName "` could return a `undeclaredParameters` value like: `"fields": [ { "name": "UserId", "type": { "code": "INT64" } }, { "name": "UserName", "type": { "code": "STRING" } }, ]`

rowType

object ( StructType )

Indicates the field names and types for the rows in the result set. For example, a SQL query like "SELECT UserId, UserName FROM Users" could return a rowType value like:

 "fields": [
  { "name": "UserId", "type": { "code": "INT64" } },
  { "name": "UserName", "type": { "code": "STRING" } },
]

transaction

object ( Transaction )

If the read or SQL query began a transaction as a side-effect, the information about the new transaction is yielded here.

undeclaredParameters

object ( StructType )

A SQL query can be parameterized. In PLAN mode, these parameters can be undeclared. This indicates the field names and types for those undeclared parameters in the SQL query. For example, a SQL query like "SELECT * FROM Users where UserId = @userId and UserName = @userName " could return a undeclaredParameters value like:

 "fields": [
  { "name": "UserId", "type": { "code": "INT64" } },
  { "name": "UserName", "type": { "code": "STRING" } },
]

ResultSetMetadata Stay organized with collections Save and categorize content based on your preferences.

ResultSetMetadata