### Navigation

- index
- modules |
- next |
- previous |
- pandas 0.13.1 documentation »
- API Reference »

# 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

### Navigation

- index
- modules |
- next |
- previous |
- pandas 0.13.1 documentation »
- API Reference »