Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

source-google-sheets-native: Improve handling of non-sheets #2032

Open
jonwihl opened this issue Oct 9, 2024 · 0 comments
Open

source-google-sheets-native: Improve handling of non-sheets #2032

jonwihl opened this issue Oct 9, 2024 · 0 comments
Assignees

Comments

@jonwihl
Copy link
Contributor

jonwihl commented Oct 9, 2024

We ran into an issue where one of the sheets in a spreadsheet was a BigQuery connection and couldn't be read. Im recommending two improvements to the connector:

  • We should filter out sheets that can't be processed from the list of sheets to read. Currently we only check if sheets exist or if any data is in a sheet before processing
  • We should also add the ability to define a range for capturing from a sheet. This can be broken out into a separate request. You can bake the rows into the initial request we make to the Sheets API
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants