Skip to content

BigQuery: Add support for sheets ranges #9082

Closed
@tswast

Description

@tswast

GoogleSheetsOptions now has a (beta) property called range. This allows you to query a sheet other than the first sheet or query a specific subset of a sheet.

https://cloud.google.com/bigquery/docs/reference/rest/v2/tables#GoogleSheetsOptions

This option applies to

  • external table definitions in query jobs
  • creating a table with an external table definition

Metadata

Metadata

Assignees

Labels

api: bigqueryIssues related to the BigQuery API.type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions