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 the Python setup instructions in the BigQuery quickstart using client libraries. For more information, see the BigQuery Python API reference documentation.

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

from google.cloud import bigquery import bigframes.pandas as bpd # Project ID inserted based on the query results selected to explore project = your_project_id # Location inserted based on the query results selected to explore location = "us" client = bigquery.Client(project=project, location=location) # Job ID inserted based on the query results selcted to explore job_id = JOB_ID job = 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 the Google Cloud sample browser.