Hey guys, we resolved the above query by specifying

query_acceleration_max_scale_factor=0

in the

pulumi_snowflake.Warehouse

, thanks for your attention