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"]],[],[[["The `pandas-gbq` package can be used to execute queries against BigQuery."],["This example demonstrates running a query with legacy SQL syntax using `pandas-gbq`."],["The `read_gbq` function is used to execute the SQL query and retrieve the results."],["To use legacy SQL syntax, set the `dialect` parameter to `\"legacy\"` in the `read_gbq` function."],["Authenticating with Bigquery requires setting up Application Default Credentials."]]],[]]