Feature Requests

I want to be able to cache the last month of data on my local machine so I don't have to go back to MotherDuck every time to run a query. As opposed to USE database I want to be able to do CACHE database, and only use MotherDuck for the heavy-duty queries. I want to be able to do this from the Web UI (user experience). Lots of queries in the apps we build could just run in the local browser version.

Would love to run Motherduck with cloud-hosted Metabase. While a Community connector exists, it's not compatible with their cloud offering. For more details: https://www.metabase.com/data_sources/

It would be good to support 2FA, possibly through an app like Authy. Created on behalf of John Apps.

Users should be able to run in other regions around the world. AWS US-WEST is one.

Pivoting data from a query result in a notebook cell is clunky, and if I create a pivot and then select 'download', I get the full query set and not the pivoted result. I would love to see a dedicated and more fully featured UI separate from notebooks, where you can build reports with the pivot functionality, and schedule results to be emailed on a regular basis, visualize results, etc.

MotherDuck should run on Azure compute

Role-based access control

Possibly append a timestamp or randomly generated words

Those with many users and accounts, regular or service, have a need to list ALL uers in their organisation in order to keep track of which user has which tokens registered on MotherDuck.