Run a legacy SQL query with pandas-gbq
Stay organized with collections
Save and categorize content based on your preferences.
Use the pandas-gbq package to run a query using legacy SQL syntax.
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\u003eThe \u003ccode\u003epandas-gbq\u003c/code\u003e package can be used to execute queries against BigQuery.\u003c/p\u003e\n"],["\u003cp\u003eThis example demonstrates running a query with legacy SQL syntax using \u003ccode\u003epandas-gbq\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eread_gbq\u003c/code\u003e function is used to execute the SQL query and retrieve the results.\u003c/p\u003e\n"],["\u003cp\u003eTo use legacy SQL syntax, set the \u003ccode\u003edialect\u003c/code\u003e parameter to \u003ccode\u003e"legacy"\u003c/code\u003e in the \u003ccode\u003eread_gbq\u003c/code\u003e function.\u003c/p\u003e\n"],["\u003cp\u003eAuthenticating with Bigquery requires setting up Application Default Credentials.\u003c/p\u003e\n"]]],[],null,[]]