Can we Alter the Size of a Warehouse in Snowflake through an open query through SQL Server?

0
votes

I just wanted to know if we can Alter the Size of a Warehouse in Snowflake through an open query using SQL Server. I do have linked server from SQL to Snowflake created. I am able to do a normal select from SQL Server to Snowflake.

1
sql-server-2016snowflake-cloud-data-platform

1 Answers

0
votes

You should be able to change the size of the warehouse using SQL: alter warehouse my_wh set warehouse_size=medium; Details here

Given you have the access privileges to operate the warehouse. Details here