Here how to find and replace tables in questions and dashboards

Tips and Tricks
1

Hi here,

this is my first post. We (Untitled Data Company) recently supported one of our clients with a migration of their transformation tool (from a custom solution to dbt). This was also a good time to rework their data model and re-organize schemas and tables.

We ended up with all our tables with new schemas and names, some even with renamed columns. Over time this customer had built thousands of questions and dashboards, and, while we were able to drop some of them, we still had a lot of them to remap on the new tables.

After looking around for a solution, we ended up building our own tool with Python + Metabase API + a lot of trial and error.

We are now open-sourcing this tool for anyone who has a similar problem. You can find it in our github.

Thanks for the attention and let us know what you think about it

2

Thanks for sharing this. One more star on the repo :wink:

1 Like
3

Thanks, I hope it helps :slight_smile:

4

I recently did something similar but hacked up the Metabase database directly! :mechanical_arm: :rofl:

1 Like
5

We were using the hosted Metabase. I don't think we can directly access that database :slight_smile: