[
https://issues.apache.org/jira/browse/DRILL-8335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17617779#comment-17617779
]
ASF GitHub Bot commented on DRILL-8335:
---------------------------------------
cgivre opened a new pull request, #2680:
URL: https://github.com/apache/drill/pull/2680
# [DRILL-8335](https://issues.apache.org/jira/browse/DRILL-8335): Add
Ability to Query GoogleSheets Tabs by Index
## Description
This PR adds the ability to query Google Sheets tabs by index rather than by
name.
## Documentation
Updated docs.
### Accessing Tabs by Index
If you don't know the names of the available tabs in your GoogleSheets
document, you can query the sheets by index using the `tab[n]` format.
Indexing starts at zero and every Sheets document must have at least one sheet.
Note that this must be enclosed in backticks.
```sql
SELECT *
FROM googlesheets.<sheet id>.`tab[0]`
```
## Testing
Added additional unit tests.
> Add Ability to Query GoogleSheets Tabs by Index
> -----------------------------------------------
>
> Key: DRILL-8335
> URL: https://issues.apache.org/jira/browse/DRILL-8335
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - GoogleSheets
> Affects Versions: 1.20.2
> Reporter: Charles Givre
> Assignee: Charles Givre
> Priority: Major
> Fix For: 2.0.0
>
>
> The GoogleSheets plugin does not provide a way for a user to query data if
> they do not know the available tab names. This adds the ability to query by
> index of the tabs.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
