ó Mîhœ$ãó•SrSSKJr SSKJrJr SSKrSSKJr SSK J r \(a SSK J r SSK Jr S rS S S jjrSSS jjrg)zGoogle BigQuery support é)Ú annotations)Ú TYPE_CHECKINGÚAnyN©Úimport_optional_dependency)Úfind_stack_level)Ú Credentials)Ú DataFramecó•Sn[SUS9nU$)Nzjpandas-gbq is required to load data from Google BigQuery. See the docs: https://pandas-gbq.readthedocs.io.Ú pandas_gbq)Úextrar)Úmsgr s Ú?/var/www/html/env/lib/python3.13/site-packages/pandas/io/gbq.pyÚ _try_importrs €ð ;ðô,¨LÀÑD€JØ Ðóc ó¼•[R"S[[5S9 [ 5n 0nU bX®S'U bX¾S'XÎS'U R "U4UUUUUUUUU S. UD6$)a© Load data from Google BigQuery. .. deprecated:: 2.2.0 Please use ``pandas_gbq.read_gbq`` instead. 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 : 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 `_. 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 `__. ``'standard'`` Use BigQuery's standard SQL, which is compliant with the SQL 2011 standard. For more information see `BigQuery Standard SQL Reference `__. 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*. use_bqstorage_api : bool, default False Use the `BigQuery Storage API `__ to download query results quickly, but at an increased cost. To use this API, first `enable it in the Cloud Console `__. You must also have the `bigquery.readsessions.create `__ 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 `__ 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 `_ >>> 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Ú FutureWarningrrÚread_gbq)Úqueryrrrrrrrrr rrrr Úkwargss rr$r$sš€ôz ‡M‚Mð Sô Ü#Ó%ò ô“€Jà13€FðÑ$Ø&7Ð"Ñ#ØÑØ +ˆ}Ñà"3Ð Ñð × Ò Ø ð àØØØØ1ØØØ#Øñ ð ñ ð rc óŽ•[R"S[[5S9 [ 5n U R UUUUUUUUUU U S9 g)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#rrÚto_gbq) Ú dataframeÚdestination_tablerr(rr)rr*rr+r r s rr,r,Þs^€ô ‡M‚Mð Qô Ü#Ó%ò ô“€JØ×ÑØØØØØØØ1Ø!ØØ!Øðò r) NNNFTNNNNNNN)r%Ústrrú str | Nonerr0rzlist[str] | NonerÚboolrr1rr0rr0rzdict[str, Any] | Noner úCredentials | Nonerz bool | Nonerú int | Nonerr0Úreturnr ) NNFÚfailTNNTN)r-r r.r/rr0r(r3rr1r)r/rr1r*zlist[dict[str, str]] | Nonerr0r+r1r r2r4ÚNone)Ú__doc__Ú __future__rÚtypingrrr!Úpandas.compat._optionalrÚpandas.util._exceptionsrÚgoogle.auth.credentialsr Úpandasr rr$r,©rrÚr?s‚ðÙÝ"÷óå>Ý4æÝ3å òð"Ø Ø"&ØØ!%ØØØ+/Ø&*Ø%)Ø"Ø$(ð}Ø ð}àð}ðð}ð ð }ð ð }ð ð }ðð}ðð}ð)ð}ð$ð}ð#ð}ðð}ð"ð}ðõ}ðF"Ø ØØØ!%Ø04ØØØ&*ð!Øð!àð!ðð!ðð !ð ð !ð ð !ðð!ð.ð!ðð!ðð!ð$ð!ð ö!r