8 ms·
I often wind up needing kind of the opposite of this: a spreadsheet as a view on a complex SQL query I've written, so that folks can manipulate the results them
by macNchz 10y ago
I often wind up needing kind of the opposite of this: a spreadsheet as a view on a complex SQL query I've written, so that folks can manipulate the results themselves.
A quick way I've set this up with Google Sheets is via IMPORTDATA(), combined with a url that dumps a csv of my query results. That way people can do all sorts of analysis and manipulation in a different tab while being able to refresh the underlying data. https://support.google.com/docs/answer/3093335?hl=en https://support.google.com/docs/answer/3093335?hl=en