Where are the queries saved?

[jornh]

Good points @AndrewMBaines!

One comment

@AndrewMBaines

The native is helpful, the query not so much.

Well, not at first look. But I speculate it's "MBQL" - short for MetaBase Query Language. For MBQL queries it looks like you then also need to lookup field-id and source-table identifies, which you then of course also have to find in the Metabase database.

Update - oh and ...

Copy dashboards and questions from one server to another

I’ll answer my own question! First, there’s no ‘proper’ way to do this. Second, it can be tricky to maintain stuff like the database_id if you try and copy across. Third, make sure you’re using a real database for your dashboards (I used MySQL). Start of by making a copy of your customer’s database on your local server. Have multiple bat files (I’m working in Windows) to start the jar, one for each customer. Modify the database connection strings to work with your local database once runni…

.. seems quite relavant to link to in this context as well