Change 573393 had a related patch set uploaded (by Ottomata; owner: Ottomata):
[operations/puppet@production] Set Superset UPLOAD_FOLDER to /tmp/superset_uploads/

https://gerrit.wikimedia.org/r/573393

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?

Sounds good, +1

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..).

Change 573393 merged by Ottomata:
[operations/puppet@production] Set Superset UPLOAD_FOLDER to /tmp/superset_uploads/

https://gerrit.wikimedia.org/r/573393

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.

Thank you @Ottomata and @Nuria! i will try out and share with other teams.

pinging also @EYener in FR so she knows this is an easy way to prototype dashboards from ad hoc data sources, just a csv file is needed

Hi @Nuria and all, we're ready to try a 'mock' data set as well. Can someone point me toward instructions on accessing and utilizing the staging environment so that I can get started with the upload? Thank you!

@EYener CVS uploads are enabled on http://superset.wikimedia.org so no special access needed

Thank you, @Nuria ! It works seamlessly.