Superset has a CSV upload capability, which could be very useful for building dashboards from static external datasets. We have an analytics MySQL 'staging' db which is used for custom user tables. We should allow superset users to upload smallish CSVs to the MySQL staging db, resulting in new tables created there.
|operations/puppet||production||+9 -0||Set Superset UPLOAD_FOLDER to /tmp/superset_uploads/|
We just need https://gerrit.wikimedia.org/r/c/operations/puppet/+/573393. That + enabling this for the mysql_staging database in superset (which I already did) works!
Is there a reason not to do this?
Past me filed a similar code change in the past: https://gerrit.wikimedia.org/r/#/c/operations/puppet/+/479408/
Moritz suggested to modify Superset's systemd unit to add PrivateTmp=true. I am +1 as long as the staging db is the one on dbstore (not db1108/eventlogging etc..).
Tested that this works well, pretty easy to create cc @cchen so she knows this is a possible option, tables have to be created on the mysql_staging database cc @kzimmerman cause uploading cvs can aide with use cases like the ones we have seen for dashboards that dana's group was making from multiple data sources.