I use Metabase to create and manage hundreds of reports. These reports are based on a view called
view_123 on the prod database. I want to change the view for all of these reports to
view_321, which uses
view_123 as a source. I also want to change the database of the report to a different one. How can I do this easily with a SQL query?
Do I have to play with the
report_card table from Metabaseapp ?
How do I recreate the hash of the query ?
You need to copy the clojure code that hashes the queries
Why didn’t you simply edit the query metadata ? You don’t need to edit the hashes
I require modifications to be made to all my reports and models within Metabase. Specifically, I need to rename the table
tbl_2 in all my reports, as well as switch to a different database. As an example, I want to change:
SELECT * FROM tbl_1
SELECT * FROM tbl_2