使用永久表查询 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 guide demonstrates how to query data from a Google Sheets file by creating a permanent table in BigQuery using both Java and Python."],["The process involves setting up authentication with the necessary scopes for BigQuery and Google Drive access, then configuring an external data source linked to the Google Sheets file."],["You can define the schema, skip header rows, and specify a range within the Google Sheets to include in the table."],["The samples include example queries that can be run against the newly created permanent table, like filtering for states whose names start with 'W'."],["You can find more code samples for other Google Cloud Products on the Google Cloud sample browser."]]],[]]