ó šxŠ\c @ssdZddlZd„Zdddeeddddddd„ Zddededdedddd„ ZdS(s Google BigQuery support iÿÿÿÿNcCs4yddl}Wntk r/tdƒ‚nX|S(NiÿÿÿÿsÚLoad data from Google BigQuery the pandas-gbq package is not installed see the docs: https://pandas-gbq.readthedocs.io you can install via pip or conda: pip install pandas-gbq conda install pandas-gbq -c conda-forge (t pandas_gbqt ImportError(R((s,lib/python2.7/site-packages/pandas/io/gbq.pyt _try_imports   c Csƒtƒ} |dkr4d}tjdtddƒn| j|d|d|d|d|d |d |d |d |d | d| d| ƒ S(sÚ Load data from Google BigQuery. This function requires the `pandas-gbq package `__. See the `How to authenticate with Google BigQuery `__ guide for authentication instructions. Parameters ---------- query : str SQL-Like Query to return data values. project_id : str, optional Google BigQuery Account project ID. Optional when available from the environment. index_col : str, optional Name of result column to use for index in results DataFrame. col_order : list(str), optional List of BigQuery column names in the desired order for results DataFrame. reauth : boolean, default False Force Google BigQuery to re-authenticate the user. This is useful if multiple accounts are used. auth_local_webserver : boolean, default False Use the `local webserver flow`_ instead of the `console flow`_ when getting user credentials. .. _local webserver flow: http://google-auth-oauthlib.readthedocs.io/en/latest/reference/google_auth_oauthlib.flow.html#google_auth_oauthlib.flow.InstalledAppFlow.run_local_server .. _console flow: http://google-auth-oauthlib.readthedocs.io/en/latest/reference/google_auth_oauthlib.flow.html#google_auth_oauthlib.flow.InstalledAppFlow.run_console *New in version 0.2.0 of pandas-gbq*. dialect : str, default 'legacy' Note: The default value is changing to 'standard' in a future verion. SQL syntax dialect to use. Value can be one of: ``'legacy'`` Use BigQuery's legacy SQL dialect. For more information see `BigQuery Legacy SQL Reference `__. ``'standard'`` Use BigQuery's standard SQL, which is compliant with the SQL 2011 standard. For more information see `BigQuery Standard SQL Reference `__. .. versionchanged:: 0.24.0 location : str, optional Location where the query job should run. See the `BigQuery locations documentation `__ for a list of available locations. The location must match that of any datasets used in the query. *New in version 0.5.0 of pandas-gbq*. configuration : dict, optional Query config parameters for job processing. For example: configuration = {'query': {'useQueryCache': False}} For more information see `BigQuery REST API Reference `__. credentials : google.auth.credentials.Credentials, optional Credentials for accessing Google APIs. Use this parameter to override default credentials, such as to use Compute Engine :class:`google.auth.compute_engine.Credentials` or Service Account :class:`google.oauth2.service_account.Credentials` directly. *New in version 0.8.0 of pandas-gbq*. .. versionadded:: 0.24.0 private_key : str, deprecated Deprecated in pandas-gbq version 0.8.0. Use the ``credentials`` parameter and :func:`google.oauth2.service_account.Credentials.from_service_account_info` or :func:`google.oauth2.service_account.Credentials.from_service_account_file` instead. Service account private key in JSON format. Can be file path or string contents. This is useful for remote server authentication (eg. Jupyter/IPython notebook on remote host). verbose : None, deprecated Deprecated in pandas-gbq version 0.4.0. Use the `logging module to adjust verbosity instead `__. Returns ------- df: DataFrame DataFrame representing results of query. See Also -------- pandas_gbq.read_gbq : This function in the pandas-gbq library. pandas.DataFrame.to_gbq : Write a DataFrame to Google BigQuery. tlegacysŒThe default value for dialect is changing to "standard" in a future version of pandas-gbq. Pass in dialect="legacy" to disable this warning.t stacklevelit project_idt index_colt col_ordertreauthtauth_local_webservertdialecttlocationt configurationt credentialstverboset private_keyN(RtNonetwarningstwarnt FutureWarningtread_gbq( tqueryRRRRR R R R R RRR((s,lib/python2.7/site-packages/pandas/io/gbq.pyRsj      tfailc Cs[tƒ} | j||d|d|d|d|d|d|d|d| d | d | d | ƒ S( NRt chunksizeRt if_existsR t table_schemaR t progress_barR RR(Rtto_gbq(t dataframetdestination_tableRRRRR RR RR RRR((s,lib/python2.7/site-packages/pandas/io/gbq.pyR˜s   (t__doc__RRRtFalseRtTrueR(((s,lib/python2.7/site-packages/pandas/io/gbq.pyts     {