Execute Query Metadata Stay organized with collections Save and categorize content based on your preferences.

This module provides the SqlType class used for specifying types in ExecuteQuery and some utilities.

The SqlTypes are used in Metadata returned by the ExecuteQuery operation as well as for specifying query parameter types explicitly.

class google.cloud.bigtable.data.execute_query.metadata.Metadata(columns: Optional[List[Tuple[Optional[str], google.cloud.bigtable.data.execute_query.metadata.SqlType.Type]]] = None)

Bases: object

Metadata class for the ExecuteQuery operation.

• Parameters

  columns (List[Tuple[Optional[str], **SqlType.Type]]) List of column metadata tuples. Each tuple contains the column name and the column type.

class google.cloud.bigtable.data.execute_query.metadata.SqlType()

Bases: object

Classes denoting types of values returned by Bigtables ExecuteQuery operation.

Used in Metadata.

class Array(element_type: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type)

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Array SQL type.

class Bool()

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Bool SQL type.

expected_type()

alias of bool

class Bytes()

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Bytes SQL type.

expected_type()

alias of bytes

class Date()

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Date SQL type.

expected_type()

alias of datetime.date

class Enum()

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Enum SQL type.

class Float32()

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Float32 SQL type.

expected_type()

alias of float

class Float64()

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Float64 SQL type.

expected_type()

alias of float

class Int64()

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Int64 SQL type.

expected_type()

alias of int

class Map(key_type: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type, value_type: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type)

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Map SQL type.

class Proto()

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Proto SQL type.

class String()

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

String SQL type.

expected_type()

alias of str

class Struct(fields: Optional[List[Tuple[Optional[str], google.cloud.bigtable.data.execute_query.values.T]]] = None)

Bases: google.cloud.bigtable.data.execute_query.values._NamedList[google.cloud.bigtable.data.execute_query.metadata.SqlType.Type], google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Struct SQL type.

class Timestamp()

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Timestamp SQL type.

Timestamp supports DatetimeWithNanoseconds but Bigtable SQL does not currently support nanoseconds precision. We support this for potential compatibility in the future. Nanoseconds are currently ignored.