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 table’s schema.

  • partition_columns (Mapping[str, str], optional) – The table’s 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

On this page

This Page