I know you are busy, but...
Your marketing department is hounding you for data exports, they want to crunch the numbers, make a cohort analysis, make fancy graphs for your investors, calculate the PPCAC2x index based on the whatever...
Can't you just make a CSV export?
The data they need is in your application database, you could just give them the database
but that would be irresponsible... or would it?...
Nah, and they don't know SQL anyway...
It's urgent, the investor meeting is in 30 minutes!
Every week, every month... 3 days before the end of the fiscal year: "Hey can you export the users table for me, I need to present this to the board on monday" .(Received on slack at 14:00 on a Friday)
Let's automate these task for you.
|1||Jackemail@example.com||2023-09-24 16:28:00||2023-09-24 16:02:00||2023-09-24 15:42:00|
|2||Jackfirstname.lastname@example.org||2023-09-24 16:28:00||2023-09-24 15:14:00||2023-09-24 14:53:00|
|3||Jackemail@example.com||2023-09-24 16:28:00||2023-09-24 15:42:00||2023-09-24 15:51:00|
|4||Jackfirstname.lastname@example.org||2023-09-24 16:28:00||2023-09-24 14:57:00||2023-09-24 15:53:00|
|5||Jackemail@example.com||2023-09-24 16:28:00||2023-09-24 15:44:00||2023-09-24 15:20:00|
MySQL and Postgres
A "Connection" in DB2Sheets is a database connection that you have configured in the app (host, port, user/pass etc), we don't arbitrarily limit how many connections you can configure, therefore "unlimited".
A "Run" is basically, when you either Manually run a Query, or whenever a schedule Runs your Query (and sends the data to Google Sheets), we don't arbitrarily limit how many times or how often you can run a Query, manually or by schedule.
The database username and password is encrypted in-transit and at rest (aka, if our database is leaked, the data is unusable).
We only connect to your database with a Read-Only connection to ensure that we cannot alter or delete any of your data.
We need access to Google Drive because that is where your Google Sheets are stored, the Google Sheets API alone does not allow "listing" all your sheets.
So we have to pull them out of your Google Drive instead.
We need "write" permission to be able to save new Sheets in your Google Drive.
You can schedule a Query to run Daily, Weekly or Monthly.
Hourly intervals is coming soon.
We don't restrict how often you can manually run a Query.