dbt-duckdb icon indicating copy to clipboard operation
dbt-duckdb copied to clipboard

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

Open Thootje opened this issue 2 years ago • 1 comments

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.

Thootje avatar Jul 10 '23 16:07 Thootje

A PR would be most welcome— thank you!

jwills avatar Jul 10 '23 16:07 jwills