- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mass updating dataset sources
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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"
}
}
]
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

Helpful resources
User | Count |
---|---|
22 | |
15 | |
15 | |
15 | |
10 |