There is a difference between the Snowflake Enterprise system and the Snowflake Standard system when extracting data for warehouses. See attached. Notice that the top result set for the "SHOW WAREHOUSES" command's eighth position is the column "is_current" which tells us the warehouse to use. This is the Standard edition and what ADS expects. Notice that the bottom result set output, which is from the Enterprise Snowflake system, has the column "running" in the eighth position. This is not expected and therefore will produce bad results. Don't know why there is such a difference within the Snowflake database.
We need to change the code to use column names instead of positions to extract warehouse data.
ADS V20.5 - SVN #57539
[Nhi] Code changes look good. Query Analyzer now shows the correct default warehouse.