dbt-duckdb
dbt-duckdb copied to clipboard
Allow Google Sheets plug-in to select data by range as well
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.
A PR would be most welcome— thank you!