使用 pandas-gbq 运行旧版 SQL 查询
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
使用 pandas-gbq 软件包通过旧版 SQL 语法运行查询。
代码示例
如未另行说明,那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可,并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情,请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","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,["# Run a legacy SQL query with pandas-gbq\n\nUse the pandas-gbq package to run a query using legacy SQL syntax.\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 sql = \"\"\"\n SELECT country_name, alpha_2_code\n FROM [bigquery-public-data:utility_us.country_code_iso]\n WHERE alpha_2_code LIKE 'Z%'\n \"\"\"\n df = pandas_gbq.read_gbq(\n sql,\n project_id=project_id,\n # Set the dialect to \"legacy\" to use legacy SQL syntax. As of\n # pandas-gbq version 0.10.0, the default dialect is \"standard\".\n dialect=\"legacy\",\n )\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)."]]