I’m wondering if there is any consideration to managing configuration across multiple environment to allow for creating metrics/questions/pulses/etc. in a development environment, promoting it to the QA environment, then promoting it to production.
Do any of you have similar needs and ideas of how to achieve it?
I would really be interested in this as well. It would really be nice if there could be some sort of git integration as well, where you could check you changes into a repos, and deploy out to QA and Prod.
@just1689 Does anybody know if there is a way to export objects? I have done a bit of looking in the repository database, and see where the reports are defined (in the report_card) table. But there are foreign keys which reference other objects defined in other tables. ex: database/table/columns. So it would not be so simple as just extracting that row, and then inserting into the other environment.
I am wondering does anybody have a thought on how to just export a report definition?
Bump! We started integrating Metabase at our company and need to deploy it for several different clients. We’d like to keep the metadata intact but allow the clients to create their own questions. The problem is how do we handle table additions and similar updates? Right now, when an update happens, we can either keep the client-specific questions and rewrite the generic metadata from scratch, or lose the client-specific questions and keep the metadata.
Although Metabase tries its best to infer as much as it possibly can about our large database, a lot of type information is still missing and many fields need to be corrected by hand (implying the need for a full manual inspection). This unfortunately renders it unusable in the long run.
Any effort that would push the project closer to scalability and manageability in such a scenario would be greatly appreciated! So far, we’ve had an amazing experience with the tool, and we definitely have big plans with Metabase. We will, of course, contribute any tweaks and improvements back to the community!
Thanks for Metabase, and thanks again for giving it such a sleek design.
Working for a financial firm we have very strict rules on who can query a production database. All queries that access a production database need to go through rigorous load testing and qa to ensure they aren’t leaking data. Metabase is a fantastic product but not being able to version / ci/cd / qa queries before the make it to production severely limits our ability to adopt this product. Anything done to improve this that allows for versioning and deployment to different environments would be extremely useful
That’s pretty awesome, thanks for creating and making it open source! One thing that’s definitely coming up more often is a more programmatic way to create/update questions so we appreciate having this example.
I should note that the Enterprise Edition has aserialization feature that allows you to copy the contents of one Metabase instance to another. That’s definitely intended more for keeping different instances in sync, though, as opposed to iterative development on a specific question or dashboard.
I know this question is really old, but I’ve been working on a solution that works not only for cards, but for dashboards. https://www.nuget.org/packages/MetabaseCLI/
This is a cli tool that runs on dotnet 5.
You can use metabase-cli -h on the terminal to see the available commands.