How to update several reports at once

Get Help
1

Hello,

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 ?

2

How do I recreate the hash of the query ?
persisted_info , query,and query_execution table

3

You need to copy the clojure code that hashes the queries

4

Why didn’t you simply edit the query metadata ? You don’t need to edit the hashes

5

I require modifications to be made to all my reports and models within Metabase. Specifically, I need to rename the table tbl_1 to tbl_2 in all my reports, as well as switch to a different database. As an example, I want to change:

From:

SELECT * FROM tbl_1

To:
SELECT * FROM tbl_2