gsheets-db-api

gsheets-db-api copied to clipboard

When doing a query in Superset with time granularity, the query fails. ```sql SELECT DATETIME(STRFTIME('%Y-%m-%dT%H:00:00', "DateTime")) AS __timestamp, COUNT(*) AS count FROM "https://docs.google.com/spreadsheets/d/1x5q4jaX54Ob0aT-0rBbECv_Q9xwqiYR41LwYVSwgavE/edit?usp=sharing" WHERE "DateTime" >= '2020-04-16 00:00:00.000000' AND "DateTime"...

eugeniamz

In addition to specify the URL, the header lines, and the schema, add the "table" alias as well. I was really excited when I first saw the [catalog example](https://docs.google.com/spreadsheets/d/1AAqVVSpGeyRZyrr4n--fb_IxhLwwKtLbjfu4h6MyyYA/edit#gid=0), when...

jqnatividad

Wouldn't it be easier to open the Google spreadsheet as a _database_, then use worksheets as _tables_? And eliminate the need for an intermediate catalog? Like this: ```python from sqlalchemy...

jrjsmrtn

Just a quick question, does this library allow for writing of data back up to Sheets, or just reading data from it? Having played around with it with SQLAlchemy, the...

gbaman

Handle `COUNT(*)` outside of `SELECT`

1

The `CountStar` processor should handle more cases, eg: ```sql SELECT country , COUNT(*) FROM table WHERE name = 'John' GROUP BY country HAVING COUNT(*) > 100 ```

betodealmeida

Bumps [certifi](https://github.com/certifi/python-certifi) from 2020.6.20 to 2022.12.7. Commits 9e9e840 2022.12.07 b81bdb2 2022.09.24 939a28f 2022.09.14 aca828a 2022.06.15.2 de0eae1 Only use importlib.resources's new files() / Traversable API on Python ≥3.11 ... b8eb5e9 2022.06.15.1...

dependabot[bot]