search

duckdb / dbt-duckdb

dbt (http://getdbt.com) adapter for DuckDB (http://duckdb.org)
Apache License 2.0
797 stars 69 forks source link

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

Open Thootje opened 1 year ago

Thootje commented 1 year ago

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 commented 1 year ago

A PR would be most welcome— thank you!