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

Allow Google Sheets plug-in to select data by range as well #213

Open
Thootje opened this issue Jul 10, 2023 · 1 comment
Open

Allow Google Sheets plug-in to select data by range as well #213

Thootje opened this issue Jul 10, 2023 · 1 comment

Comments

@Thootje
Copy link
Contributor

Thootje commented Jul 10, 2023

Hi! First off, thanks for the great work on this adapter!

I'm using dbt-duckdb to fetch data from Google Sheets and then transform and output it. Apart from being able to select an entire sheet, which is done using the get_all_records() method, I'd also like to select a range instead of all records.

gspread offers this feature through the .get() method. You can pass a range using A1 notation inside that method to select a certain range instead of the entire sheet.

I'd be happy to make a PR for this if needed.

@jwills
Copy link
Collaborator

jwills commented Jul 10, 2023

A PR would be most welcome— thank you!

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