Bulk update datasource type

Some more info:
Synapse and Snowflake table/schema structures are same.

The query patterns are following:

Synapse:

let
Source = Sql.Database("Synpase Server", "Synapse Database"),
AdventureWorksDW2017 = Source{[Name="AdventureWorks"]}[Data],
dbo_DimProduct = AdventureWorksDW2017{[Schema="dbo",Item="DimProduct"]}[Data]
in
dbo_DimProduct

Also we have seen this -
let
Source = Sql.Databases("Synpase Server"),
#"dw-prod" = Source{[Name="Synapse Database"]}[Data],
dbo_DimCustomer = #"dw-prod"{[Schema="dbo",Item="DimCustomer"]}[Data]
in
dbo_DimCustomer
----------------------------------------------------------------------------------------------
For Snowflake:

let
Source = Snowflake.Databases("Snowflake Server", "Snowflake Warehouse", null),
Test_Database = Source{[Name="Test",Kind="Database"]}[Data],
IM_Schema = Test_Database{[Name="IM",Kind="Schema"]}[Data],
Test1_Table = IM_Schema{[Name="Test1",Kind="Table"]}[Data],
in
Test1_Table