使用永久表查询 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"]],[],[[["\u003cp\u003eThis guide demonstrates how to query data from a Google Sheets file by creating a permanent table in BigQuery using both Java and Python.\u003c/p\u003e\n"],["\u003cp\u003eThe 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.\u003c/p\u003e\n"],["\u003cp\u003eYou can define the schema, skip header rows, and specify a range within the Google Sheets to include in the table.\u003c/p\u003e\n"],["\u003cp\u003eThe samples include example queries that can be run against the newly created permanent table, like filtering for states whose names start with 'W'.\u003c/p\u003e\n"],["\u003cp\u003eYou can find more code samples for other Google Cloud Products on the Google Cloud sample browser.\u003c/p\u003e\n"]]],[],null,[]]