3 ms·
Very cool! I built a company around SQL and Google Sheets (https://www.seekwell.io/ https://www.seekwell.io/, acquired by ThoughtSpot in 2022). Plenty of opport
by mritchie712 3y ago
Very cool! I built a company around SQL and Google Sheets (https://www.seekwell.io/ https://www.seekwell.io/, acquired by ThoughtSpot in 2022). Plenty of opportunity there.
You get a lot of this for free in duckdb. e.g. if you run the query below from the duckdb CLI, it'll query the sheet[0]:
SELECT *
FROM read_csv_auto('https://docs.google.com/spreadsheets/export?format=csv&id=1GuEPkwjdICgJ31Ji3iUoarirZNDbPxQj_kf7fd4h4Ro', normalize_names=True);
We use duckdb under the hood at my new company (https://www.definite.app/ https://www.definite.app/), so we get this same sort of functionality for free.
0 - https://twitter.com/thisritchie/status/1767922982046015840 https://twitter.com/thisritchie/status/1767922982046015840
- tarasyarema 3y agoYeah, that is actually super nice, the potential DuckDB offers to operate with data in such an easy way. With a bit of tuning on the auth side it's that easy indeed. I think it is a pain point for some people, and it's great to see other teams working on similar products and being based on the same tech.
- plaidfuji 3y agoDon’t you also get this functionality from a combination of BigQuery, Connected Sheets and ImportRange nowadays?
- tarasyarema 3y agoProbably you could do something similar, the thing is that duckdb is much more lightweight. But at the same time if you end up having billions of data points BQ is there to scale for sure jaja