- 3.36.0 (latest)
- 3.35.1
- 3.34.0
- 3.33.0
- 3.31.0
- 3.30.0
- 3.29.0
- 3.27.0
- 3.26.0
- 3.25.0
- 3.24.0
- 3.23.1
- 3.22.0
- 3.21.0
- 3.20.1
- 3.19.0
- 3.18.0
- 3.17.2
- 3.16.0
- 3.15.0
- 3.14.1
- 3.13.0
- 3.12.0
- 3.11.4
- 3.4.0
- 3.3.6
- 3.2.0
- 3.1.0
- 3.0.1
- 2.34.4
- 2.33.0
- 2.32.0
- 2.31.0
- 2.30.1
- 2.29.0
- 2.28.1
- 2.27.1
- 2.26.0
- 2.25.2
- 2.24.1
- 2.23.3
- 2.22.1
- 2.21.0
- 2.20.0
- 2.19.0
- 2.18.0
- 2.17.0
- 2.16.1
- 2.15.0
- 2.14.0
- 2.13.1
- 2.12.0
- 2.11.0
- 2.10.0
- 2.9.0
- 2.8.0
- 2.7.0
- 2.6.2
- 2.5.0
- 2.4.0
- 2.3.1
- 2.2.0
- 2.1.0
- 2.0.0
- 1.28.2
- 1.27.2
- 1.26.1
- 1.25.0
- 1.24.0
- 1.23.1
- 1.22.0
- 1.21.0
- 1.20.0
- 1.19.0
- 1.18.0
- 1.17.0
- 1.16.0
Define classes that describe external data sources.
These are used for both Table.externalDataConfiguration and Job.configuration.query.tableDefinitions.
Classes
BigtableColumn
BigtableColumn
()
Options for a Bigtable column.
BigtableColumnFamily
BigtableColumnFamily
()
Options for a Bigtable column family.
BigtableOptions
BigtableOptions
()
Options that describe how to treat Bigtable tables as BigQuery tables.
CSVOptions
CSVOptions
()
Options that describe how to treat CSV files as BigQuery tables.
ExternalCatalogDatasetOptions
ExternalCatalogDatasetOptions
(
default_storage_location_uri
:
typing
.
Optional
[
str
]
=
None
,
parameters
:
typing
.
Optional
[
typing
.
Dict
[
str
,
typing
.
Any
]]
=
None
,
)
Options defining open source compatible datasets living in the BigQuery catalog. Contains metadata of open source database, schema or namespace represented by the current dataset.
default_storage_location_uri
Optional[str]
The storage location URI for all tables in the dataset. Equivalent to hive metastore's database locationUri. Maximum length of 1024 characters. (str)
parameters
Optional[dict[str, Any]]
A map of key value pairs defining the parameters and properties of the open source schema. Maximum size of 2Mib.
ExternalCatalogTableOptions
ExternalCatalogTableOptions
(
connection_id
:
typing
.
Optional
[
str
]
=
None
,
parameters
:
typing
.
Optional
[
typing
.
Dict
[
str
,
typing
.
Any
]]
=
None
,
storage_descriptor
:
typing
.
Optional
[
google
.
cloud
.
bigquery
.
schema
.
StorageDescriptor
]
=
None
,
)
Metadata about open source compatible table. The fields contained in these options correspond to hive metastore's table level properties.
connection_id
Optional[str]
The connection specifying the credentials to be used to read external storage, such as Azure Blob, Cloud Storage, or S3. The connection is needed to read the open source table from BigQuery Engine. The connection_id can have the form ..
or projects//locations//connections/
.
parameters
Union[Dict[str, Any], None]
A map of key value pairs defining the parameters and properties of the open source table. Corresponds with hive meta store table parameters. Maximum size of 4Mib.
storage_descriptor
Optional[StorageDescriptor]
A storage descriptor containing information about the physical storage of this table.
ExternalConfig
ExternalConfig
(
source_format
)
Description of an external data source.
source_format
ExternalSourceFormat
See source_format
.
ExternalSourceFormat
ExternalSourceFormat
()
The format for external data files.
Note that the set of allowed values for external data sources is different than the set used for loading data (see SourceFormat ).
GoogleSheetsOptions
GoogleSheetsOptions
()
Options that describe how to treat Google Sheets as BigQuery tables.
HivePartitioningOptions
HivePartitioningOptions
()
[Beta] Options that configure hive partitioning.
See https://cloud.google.com/bigquery/docs/reference/rest/v2/tables#HivePartitioningOptions