使用临时表查询 Google 表格
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
通过创建临时表查询 Google 表格文件中的数据。
深入探索
如需查看包含此代码示例的详细文档,请参阅以下内容:
代码示例
如未另行说明,那么本页面中的内容已根据知识共享署名 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"]],[],[[["This content demonstrates how to query data from a Google Sheets file by creating a temporary external table within BigQuery, using both Java and Python."],["The code samples require setting up Application Default Credentials for authentication and include enabling both the BigQuery and Google Drive APIs."],["The temporary table is defined using an external configuration pointing to a Google Sheets URL, along with a defined schema and optional parameters such as skipping header rows and specifying a range."],["Example queries, such as selecting data where the name starts with 'W', are executed against this temporary table, showcasing the process of filtering data from the sheet."],["The code provided in both Python and Java has been tested to show how to query the external Google Sheets file data, as well as how to set up the code so the query is successful."]]],[]]