Create subdomain for superset dashboard

[patcon]

Re: #6

Would be rad to consider this an official resource. Can @titaniumbones give it a subdomain? (Not suggesting anything fancy like proxying to a clean subdomain or anything -- keeping the subpaths seems fine for now.)

If superset can have multiple backends, we could just use one subdomain (and not worry about considering a namespacing for both the v1 and v2 dashboard.

Possibilities

1. dashboard.archivers.space
2. metrics.archivers.space
3. stats.archivers.space

(Defer to @b5 who understands terms that aren't taken yet in the design of archivers.space :) )

Technically, the superset instance seems to have some other uses, but perhaps we could pass on that discussion for now.

cc: @titaniumbones @sonalranjit @b5

[b5]

If possible, I'd love to revisit this, thinking about stats.datatogether.org leading to a superset instance that pulls from analytics metrics

[patcon]

Didn't realize that superset was just a full python app -- could we just migrate to heroku app, and copy this (with updates)?

https://github.com/neevany/caravel-on-heroku

[sonalranjit]

@patcon ive tried deploying to heroku a few months back, was struggling with some annoying errors wasn't successful. The current instance is on a EDGI gcp vm.

[patcon]

Cool. Aside from db credentials, any config files you could paste or share in a gist, in case I want to take a stab at it?

[sonalranjit]

nope no special config files it just works out of the box. I think there is an option for migrating dashboards, if its deployed on heroku then can migrate all existing dashboard and slices. FYI Airbnb is no longer supporting superset, Apache has taken over so the docs have moved over there https://github.com/apache/incubator-superset

[dcwalk]

Just pinging @titaniumbones here, can we look at deploying to Compute Canada VM?
I think we want to contain our costs and so it might be attractive to move off GCP and if not possible to deploy on Heroku for free then Compute Canada VMs are long term free & stable infra resources

[dcwalk]

Also @b5 controls DNS so would be responsible for subdomain

[patcon]

Perf, thanks all!

Not working yet, but heroku-backed instance setup is here:
https://github.com/datatogether/datatogether-superset

Also started stubbing out a service access inventory doc for DataTogether, and heroku app is in there:
#14

Can anyone drop a quick run-down on the backends we need to support, so someone can prep heroku? https://superset.incubator.apache.org/installation.html#database-dependencies

[patcon]

Re: Compute Canada VM's

if not possible to deploy on Heroku for free then Compute Canada VMs are long term free & stable infra resources

I have a strong preference for Heroku for ease and stability of toolset, if it's a component that we don't expect to ever require a paid dyno (which I think this is). Of course, i will always try to hold my stront convictions loosely, so I'm down to discuss tonight :)

---

EDIT: Then again, this one isn't changing much, as config is via UI, not in code. but i am reeeeeaaaally partial to Heroku, as I can just give access to new people via heroku access:add [email protected], and a world of other things that are the product of a first-rate, hyper-integrated toolchain.

[patcon]

Also, the heroku instance is now working, but needs to be configured. If anyone is down, drop a msg or ping me in slack and I'll provision you an admin user!

[patcon]

Hey @b5, if you felt like pointing a subdomain at the app, I'm happy to do the CLI setup afterwards:
https://devcenter.heroku.com/articles/custom-domains#add-a-custom-domain-with-a-subdomain

(you're collab on app, but might need owner privs. If you can, feel free to do whole thing!)

thinking about stats.datatogether.org leading to a superset instance that pulls from analytics metrics

@b5 fwiw, just realize I'm not 100% on what data sources you were thinking for this. Care to expound?

[sonalranjit]

have migrated the dashboard from the GCP superset to the heroku one. https://datatogether-superset.herokuapp.com/superset/dashboard/archivers/

Feel free to shutdown the GCP superset instance