steampipe-postgres-fdw icon indicating copy to clipboard operation
steampipe-postgres-fdw copied to clipboard

named range in googlesheet only populates when known

Open judell opened this issue 3 years ago • 0 comments

Using the googlesheets plugin, I have a tab in a sheet with data in just two cells, a1:a2, and a named range that captures both. The range column populates if I ask for it explicitly. I am filing here, vs the plugin repo, because I suspect it's an fdw thing. (/cc @cbruno10 in case otherwise)

select row, col, range from reposheet.googlesheets_cell where range = 'NamedRange1';
 row | col |    range
-----+-----+-------------
   2 | A   | NamedRange1
   1 | A   | NamedRange1
(2 rows)

I don't understand this.

select row, col, range from reposheet.googlesheets_cell where range is null;
 row | col | range
-----+-----+-------
   1 | A   |
   2 | A   |
(2 rows)

judell avatar Dec 04 '21 02:12 judell