Ë
|
nñúh$ ã ó d Z ddlmZ ddlmZmZ ddlZddlmZ ddl m
|
Z
|
er ddl m Z ddl mZ d Z d d d
|
Z d dd Zy)z Google BigQuery support é )Ú annotations)Ú TYPE_CHECKINGÚAnyN©Úimport_optional_dependency)Úfind_stack_level)Ú Credentials)Ú DataFramec ó$ d} t d| ¬« }|S )Nzjpandas-gbq is required to load data from Google BigQuery. See the docs: https://pandas-gbq.readthedocs.io.Ú
|
pandas_gbq)Úextrar )Úmsgr s ú@H:\Change_password\venv_build\Lib\site-packages\pandas/io/gbq.pyÚ _try_importr s ð ;ð ô ,¨LÀÔDJØ Ðó c ó t j dt t « ¬« t « } i }|
|
|
|
|d< | | |d< | |d< | j
|
| f||||||||| d |¤S )a
|
Load data from Google BigQuery.
|
|
.. deprecated:: 2.2.0
|
|
Please use ``pandas_gbq.read_gbq`` instead.
|
|
This function requires the `pandas-gbq package
|
<https://pandas-gbq.readthedocs.io>`__.
|
|
See the `How to authenticate with Google BigQuery
|
<https://pandas-gbq.readthedocs.io/en/latest/howto/authentication.html>`__
|
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 : bool, default False
|
Force Google BigQuery to re-authenticate the user. This is useful
|
if multiple accounts are used.
|
auth_local_webserver : bool, default True
|
Use the `local webserver flow`_ instead of the `console flow`_
|
when getting user credentials.
|
|
.. _local webserver flow:
|
https://google-auth-oauthlib.readthedocs.io/en/latest/reference/google_auth_oauthlib.flow.html#google_auth_oauthlib.flow.InstalledAppFlow.run_local_server
|
.. _console flow:
|
https://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*.
|
|
.. versionchanged:: 1.5.0
|
Default value is changed to ``True``. Google has deprecated the
|
``auth_local_webserver = False`` `"out of band" (copy-paste)
|
flow
|
<https://developers.googleblog.com/2022/02/making-oauth-flows-safer.html?m=1#disallowed-oob>`_.
|
dialect : str, default 'legacy'
|
Note: The default value is changing to 'standard' in a future version.
|
|
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
|
<https://cloud.google.com/bigquery/docs/reference/legacy-sql>`__.
|
``'standard'``
|
Use BigQuery's standard SQL, which is
|
compliant with the SQL 2011 standard. For more information
|
see `BigQuery Standard SQL Reference
|
<https://cloud.google.com/bigquery/docs/reference/standard-sql/>`__.
|
location : str, optional
|
Location where the query job should run. See the `BigQuery locations
|
documentation
|
<https://cloud.google.com/bigquery/docs/dataset-locations>`__ 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
|
<https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs#configuration.query>`__.
|
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*.
|
use_bqstorage_api : bool, default False
|
Use the `BigQuery Storage API
|
<https://cloud.google.com/bigquery/docs/reference/storage/>`__ to
|
download query results quickly, but at an increased cost. To use this
|
API, first `enable it in the Cloud Console
|
<https://console.cloud.google.com/apis/library/bigquerystorage.googleapis.com>`__.
|
You must also have the `bigquery.readsessions.create
|
<https://cloud.google.com/bigquery/docs/access-control#roles>`__
|
permission on the project you are billing queries to.
|
|
This feature requires version 0.10.0 or later of the ``pandas-gbq``
|
package. It also requires the ``google-cloud-bigquery-storage`` and
|
``fastavro`` packages.
|
|
max_results : int, optional
|
If set, limit the maximum number of rows to fetch from the query
|
results.
|
|
progress_bar_type : Optional, str
|
If set, use the `tqdm <https://tqdm.github.io/>`__ library to
|
display a progress bar while the data downloads. Install the
|
``tqdm`` package to use this feature.
|
|
Possible values of ``progress_bar_type`` include:
|
|
``None``
|
No progress bar.
|
``'tqdm'``
|
Use the :func:`tqdm.tqdm` function to print a progress bar
|
to :data:`sys.stderr`.
|
``'tqdm_notebook'``
|
Use the :func:`tqdm.tqdm_notebook` function to display a
|
progress bar as a Jupyter notebook widget.
|
``'tqdm_gui'``
|
Use the :func:`tqdm.tqdm_gui` function to display a
|
progress bar as a graphical dialog box.
|
|
Returns
|
-------
|
df: DataFrame
|
DataFrame representing results of query.
|
|
See Also
|
--------
|
pandas_gbq.read_gbq : This function in the pandas-gbq library.
|
DataFrame.to_gbq : Write a DataFrame to Google BigQuery.
|
|
Examples
|
--------
|
Example taken from `Google BigQuery documentation
|
<https://cloud.google.com/bigquery/docs/pandas-gbq-migration>`_
|
|
>>> sql = "SELECT name FROM table_name WHERE state = 'TX' LIMIT 100;"
|
>>> df = pd.read_gbq(sql, dialect="standard") # doctest: +SKIP
|
>>> project_id = "your-project-id" # doctest: +SKIP
|
>>> df = pd.read_gbq(sql,
|
... project_id=project_id,
|
... dialect="standard"
|
... ) # doctest: +SKIP
|
z°read_gbq is deprecated and will be removed in a future version. Please use pandas_gbq.read_gbq instead: https://pandas-gbq.readthedocs.io/en/latest/api.html#pandas_gbq.read_gbq©Ú
|
stacklevelÚuse_bqstorage_apiÚ max_resultsÚprogress_bar_type) Ú
|
project_idÚ index_colÚ col_orderÚreauthÚauth_local_webserverÚdialectÚlocationÚ configurationÚ credentials)ÚwarningsÚwarnÚ FutureWarningr r Úread_gbq)Úqueryr r r r r r r r r r r r r Úkwargss r r$ r$ s¢ ôz MMð Sô Ü#Ó%õ ô Jà13Fð Ð$Ø&7Ð"Ñ#ØÐ Ø +}Ñ à"3FÐ Ñ ð :× Ñ Ø ð à ØØØØ 1ØØØ#Ø ñ ð ñ ð r c ó t j dt t « ¬« t « } | j | ||||||||| |
|
¬« y )Nzªto_gbq is deprecated and will be removed in a future version. Please use pandas_gbq.to_gbq instead: https://pandas-gbq.readthedocs.io/en/latest/api.html#pandas_gbq.to_gbqr ) r Ú chunksizer Ú if_existsr Ú table_schemar Ú progress_barr )r! r" r# r r Úto_gbq) Ú dataframeÚdestination_tabler r( r r) r r* r r+ r r s r r, r, Þ s^ ô MMð Qô Ü#Ó%õ ô JØ×ÑØØØ ØØØØ 1Ø!ØØ!Ø ð õ r ) NNNFTNNNNNNN) r% Ústrr ú
|
str | Noner r0 r zlist[str] | Noner Úboolr r1 r r0 r r0 r zdict[str, Any] | Noner úCredentials | Noner z bool | Noner ú
|
int | Noner r0 Úreturnr
|
) NNFÚfailTNNTN)r- r
|
r. r/ r r0 r( r3 r r1 r) r/ r r1 r* zlist[dict[str, str]] | Noner r0 r+ r1 r r2 r4 ÚNone)Ú__doc__Ú
|
__future__r Útypingr r r! Úpandas.compat._optionalr Úpandas.util._exceptionsr Úgoogle.auth.credentialsr Úpandasr
|
r r$ r, © r r ú<module>r? s ðÙ Ý "÷ó å >Ý 4áÝ3å òð "Ø Ø"&ØØ!%Ø Ø Ø+/Ø&*Ø%)Ø "Ø$(ð}Ø ð}àð}ð ð}ð ð }ð
|
ð }ð ð }ð ð}ð ð}ð )ð}ð $ð}ð #ð}ð ð}ð "ð}ð ó }ðF "Ø ØØØ!%Ø04Ø Ø Ø&*ð!Øð!àð!ð ð!ð ð !ð
|
ð !ð ð !ð ð!ð .ð!ð ð!ð ð!ð $ð!ð
|
ô!r
|
