Create a BigQuery DataFrame from a finished query job

Use the BigQuery DataFrames API to explore the results of a query job that may have been started elsewhere, such as from the BigQuery Console or bq CLI.

Code sample

Python

Before trying this sample, follow thePython setup instructions in theBigQuery quickstart using client libraries. For more information, see theBigQueryPython API reference documentation.

To authenticate to BigQuery, set up Application Default Credentials. For more information, seeSet up authentication for client libraries.

fromgoogle.cloudimportbigqueryimportbigframes.pandasasbpd# Project ID inserted based on the query results selected to exploreproject=your_project_id# Location inserted based on the query results selected to explorelocation="us"client=bigquery.Client(project=project,location=location)# Job ID inserted based on the query results selcted to explorejob_id=JOB_IDjob=client.get_job(job_id)destination=str(job.destination)# Load data from a BigQuery table using BigFrames DataFrames:bq_df=bpd.read_gbq_table(destination)

What's next

To search and filter code samples for other Google Cloud products, see theGoogle Cloud sample browser.

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.