3 ms·
I never had a problem with the Sheets V4 API that came out last May, how big of a database are you talking here?
by jboggan 9y ago
I never had a problem with the Sheets V4 API that came out last May, how big of a database are you talking here?
- teej 9y agoThe add on doesn't talk to the reporting database directly, Google's Apps Script JDBC service doesn't support Postgres/Redshift. The add on gets data from a REST API. I then have an etl job that precalculates the aggregates and stashes them in Redis that the API then reads from.
- pkpp1233 9y agoSee https://www.blockspring.com https://www.blockspring.com. The add-on has prebuilt connectors for both postgres and mysql. Can also build your own connectors https://open.blockspring.com/blocks/new https://open.blockspring.com/blocks/new.