bigframes.bigquery.create_external_table#

bigframes.bigquery.create_external_table(table_name: str, *, replace: bool = False, if_not_exists: bool = False, columns: Mapping[str, str] | None = None, partition_columns: Mapping[str, str] | None = None, connection_name: str | None = None, options: Mapping[str, str | int | float | bool | list], session: Session | None = None) → Series[source]#

Creates a BigQuery external table.

See the BigQuery CREATE EXTERNAL TABLE DDL syntax for additional reference.

Parameters:

• table_name (str) The name of the table in BigQuery.

• replace (bool, default False) Whether to replace the table if it already exists.

• if_not_exists (bool, default False) Whether to ignore the error if the table already exists.

• columns (Mapping[str, str], optional) The tables schema.

• partition_columns (Mapping[str, str], optional) The tables partition columns.

• connection_name (str, optional) The connection to use for the table.

• options (Mapping[str, Union[str, int, float, bool, list]]) The OPTIONS clause, which specifies the table options.

• session (bigframes.session.Session, optional) The session to use. If not provided, the default session is used.

Returns:

A Series with object dtype containing the table metadata. Reference the BigQuery Table REST API reference for available fields.

Return type:

pandas.Series