I have a sqlite3 database that I’d like to make viewable publicly - without people having to login. It’s actually a catalog dump from a manufacturer, and a bunch of us would like to be able to use Metabase as a GUI of sorts for this catalog. What’s a good way to achieve this? Basically, I don’t want people to be able to do admin stuff on this instance (like pointing to a new database) or save visualizations.
For an example of what I’d like to use Metabase for, check https://ec2instances.info. This doesn’t use Metabase (yet), but I’d like to create a similar view plus one that lets people sort and filter through the data, spit out fun statistics, etc.
On a slightly tangential subject, can Metabase handle structured JSON blobs? It’d need to look into the blob until it finds an array that has multiple entries with similar fields and then show a dashboard for that. Reusing ec2instances.info as an example, here’s their giant 25MB json blob database https://github.com/powdahound/ec2instances.info/blob/master/www/instances.json