Updating metadata.json on Datasette for MacOS

[ment4list]

I've installed Datasette for Mac as per the documentation and it's working great!

However, I'm not sure how to go about adding something like "Canned Queries" or utilising other advanced features or settings by manipulating the metadata.json or settings.json files.

I can view these files from the Datasette App from the top right "burger" menu but it only shows the contents of the file with no way to edit or change it.

Am I missing something? Where can I update the metadata.json file using the MacOS App?

PS: This is a fantastic tool! Thanks so much for all the effort and especially adding a bunch of different ways to get started quickly!

[ment4list]

For now I've installed datasette via homebrew.

I then converted my CSV to SQLite via sqlite-utils as per the article Cleaning data with sqlite.

Now I can use my metadata.json file as follows:

datasette mydb.db -m mymetadata.json