Moving existing reporting to a new data source

We are running into an issue where some BigQuery views and tables aren't being recognized in the Metabase schema.

While troubleshooting, we created a new database connection and those views/tables are recognized correctly in the new data source.

Is there an efficient way to update existing reporting so that it uses the new data source?

Edited: found the roadmap and see swapping data sources in the GUI is in the now section of the roadmap; is there any timeline on that?

Is it possible to update the data source for the existing reports without breaking them? If so, is it possible in bulk?

If not, what are the most efficient ways to export existing reporting in order to re-create it in the new data source?