We have ±30 datasources connected to BigQuery, most of them are garbage. But there are questions using them. So to bulk migrate the questions to other datasource, what do I need to do?
Can I simply update database_id on report_card? Like:
UPDATE report_card SET database_id = 53 WHERE id IN (questions to be migrated)