Our environments (TEST and PROD) are on the same RDBMS server, but the datais on different schemas (again, TEST and PROD). We need to be able to publish Tableau dashboards to both environments in automated way. I know there's REST API to update dashboard connection, but I haven't found anything to update schemas for datasources (other than parsing the dashboard file trying to find-replace PROD schema name with TEST).
Am I missing smth here? Could you please share alternative deployment strategies/approaches if any?