pandas.io.gbq.to_gbq¶
- pandas.io.gbq.to_gbq(dataframe, destination_table, schema=None, col_order=None, if_exists='fail', **kwargs)¶
Write a DataFrame to a Google BigQuery table.
THIS IS AN EXPERIMENTAL LIBRARY
If the table exists, the DataFrame will be appended. If not, a new table will be created, in which case the schema will have to be specified. By default, rows will be written in the order they appear in the DataFrame, though the user may specify an alternative order.
Parameters : dataframe : DataFrame
DataFrame to be written
destination_table : string
name of table to be written, in the form ‘dataset.tablename’
schema : sequence (optional)
list of column types in order for data to be inserted, e.g. [‘INTEGER’, ‘TIMESTAMP’, ‘BOOLEAN’]
col_order : sequence (optional)
order which columns are to be inserted, e.g. [‘primary_key’, ‘birthday’, ‘username’]
if_exists : {‘fail’, ‘replace’, ‘append’} (optional)
- fail: If table exists, do nothing.
- replace: If table exists, drop it, recreate it, and insert data.
- append: If table exists, insert data. Create if does not exist.
kwargs are passed to the Client constructor
Raises : SchemaMissing :
Raised if the ‘if_exists’ parameter is set to ‘replace’, but no schema is specified
TableExists :
Raised if the specified ‘destination_table’ exists but the ‘if_exists’ parameter is set to ‘fail’ (the default)
InvalidSchema :
Raised if the ‘schema’ parameter does not match the provided DataFrame