Mass updating dataset sources

[Anonymous]

Hi,

I have about 100 dataset which are connected to Snowflake. I need to update all 100 to use a new warehouse in Snowflake. The table structure will be the same in the new warehouse and will have the same database name as the old one. Basically I just need to change "xxxx.snowflakexxx.com; warehouse1" to "xxxx.snowflakexxx.com; warehouse2" on all 100 dataset. What would be the easiest way to do this? I tried using UpdateDatasources API but I couldn't get it to work with Snowflake.

[lbendlin]

I tried using UpdateDatasources API but I couldn't get it to work with Snowflake.

Please elaborate. That API call is usually agnostic to the data source it is modifying

[Anonymous]

I tried to use the Update Datasources API. however, it says on the limitations that only the following data sources are supported: SQL Server, Azure SQL Server, Azure Analysis Services, Azure Synapse, OData, SharePoint, Teradata, and SAP HANA. When I tried using it in snowflake, I get a "Parameter updatedetails is missing or invalid" error. The script works when I tried updating one of my sources in SAP.

This is the update details parameter I'm using:

 {
   "updateDetails": [
        {
            "datasourceSelector": {
                "datasourceType":"Extension",
                "connectionDetails": {
                   "path":"snowflake URL;OLD_WH","kind":"Snowflake"
                }
            },
            "connectionDetails": {
               "path":"snowflake URL;New_WH","kind":"Snowflake"
            }
        }
    ]
}

[lbendlin]

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41