The :mod:`pandas_gbq` module provides a wrapper for Google's BigQuery analytics web service to simplify retrieving results from BigQuery tables using SQL-like queries. Result sets are parsed into a :class:`pandas.DataFrame` with a shape and data types derived from the source table. Additionally, DataFrames can be inserted into new BigQuery tables or appended to existing tables.
Note: The canonical version of this documentation can always be found on the googleapis.dev pandas-gbq site.
Note
To use this module, you will need a valid BigQuery account. Use the BigQuery sandbox to try the service for free.
Also, consider using BigQuery DataFrames (bit.ly/bigframes-intro) to process large results with pandas compatible APIs with transparent SQL pushdown to BigQuery engine. This provides an opportunity to save on costs and improve performance.
While BigQuery uses standard SQL syntax, it has some important differences from traditional databases both in functionality, API limitations (size and quantity of queries or uploads), and how Google charges for use of the service. BiqQuery is best for analyzing large sets of data quickly. It is not a direct replacement for a transactional database. Refer to the BigQuery Documentation for details on the service itself.
Contents:
.. toctree:: :maxdepth: 2 install.rst intro.rst howto/authentication.rst reading.rst writing.rst api.rst contributing.rst changelog.md privacy.rst oauth.rst