Create a BigQuery DataFrame from a finished query job
Stay organized with collections
Save and categorize content based on your preferences.
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
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License
, and code samples are licensed under the Apache 2.0 License
. For details, see the Google Developers Site Policies
. Java is a registered trademark of Oracle and/or its affiliates.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],[],[[["\u003cp\u003eThis content demonstrates how to use the BigQuery DataFrames API to explore the results of a previously executed query job.\u003c/p\u003e\n"],["\u003cp\u003eThe code utilizes the \u003ccode\u003ebigframes.pandas\u003c/code\u003e library (\u003ccode\u003ebpd\u003c/code\u003e) to read data from a BigQuery table specified by the job's destination.\u003c/p\u003e\n"],["\u003cp\u003eAuthentication to BigQuery is required using Application Default Credentials, as detailed in the provided setup documentation.\u003c/p\u003e\n"],["\u003cp\u003eThe example involves retrieving a specific job using its ID and obtaining its destination for data exploration.\u003c/p\u003e\n"]]],[],null,["# Create a BigQuery DataFrame from a finished query job\n\nUse 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.\n\nCode sample\n-----------\n\n### Python\n\n\nBefore trying this sample, follow the Python setup instructions in the\n[BigQuery quickstart using\nclient libraries](/bigquery/docs/quickstarts/quickstart-client-libraries).\n\n\nFor more information, see the\n[BigQuery Python API\nreference documentation](/python/docs/reference/bigquery/latest).\n\n\nTo authenticate to BigQuery, set up Application Default Credentials.\nFor more information, see\n\n[Set up authentication for client libraries](/bigquery/docs/authentication#client-libs).\n\n from google.cloud import https://cloud.google.com/python/docs/reference/bigquery/latest/\n\n import bigframes.pandas as bpd\n\n # Project ID inserted based on the query results selected to explore\n project = your_project_id\n # Location inserted based on the query results selected to explore\n location = \"us\"\n client = https://cloud.google.com/python/docs/reference/bigquery/latest/.https://cloud.google.com/python/docs/reference/bigquery/latest/google.cloud.bigquery.client.Client.html(project=project, location=location)\n\n # Job ID inserted based on the query results selcted to explore\n job_id = JOB_ID\n job = client.https://cloud.google.com/python/docs/reference/bigquery/latest/google.cloud.bigquery.client.Client.html#google_cloud_bigquery_client_Client_get_job(job_id)\n destination = str(https://cloud.google.com/python/docs/reference/bigquery/latest/google.cloud.bigquery.job.html.destination)\n\n # Load data from a BigQuery table using BigFrames DataFrames:\n bq_df = bpd.read_gbq_table(destination)\n\nWhat's next\n-----------\n\n\nTo search and filter code samples for other Google Cloud products, see the\n[Google Cloud sample browser](/docs/samples?product=bigquery)."]]
