steampipe-postgres-fdw
steampipe-postgres-fdw copied to clipboard
named range in googlesheet only populates when known
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)