Snowflake - multiple execution warehouses can be set up to handle different sizes of query, however the warehouse forms part of the connection string, IE:
jdbc:snowflake://somesclouds.snowflakecomputing.com/?role=datamonkey&db=somedatabase&warehouse=small/medium/large
Expected behavior
Each source can be configured as a separate connection string, and each duplicate of the same source using a different execution warehouse can be displayed on a new page:
Like this for generation, and sources.
Actual behavior
The additional strings which vary only one variable of the string, become duplicate buttons, and factor scales the number of options during generation, creating an unwieldy UI experience.
Steps to reproduce behavior
Add duplicate sources with slightly different connection strings.
Proposed solution
Choice of pages to add connection to (Page 1 sources, page 2....)
Or
Parameterise the connection string variable and allow for some switch (like rc/drc) between warehouses
(Apologies, I'd love to start on this personally but I'm a little intimidated by the depths of java)
Snowflake - multiple execution warehouses can be set up to handle different sizes of query, however the warehouse forms part of the connection string, IE: jdbc:snowflake://somesclouds.snowflakecomputing.com/?role=datamonkey&db=somedatabase&warehouse=small/medium/large
Expected behavior
Each source can be configured as a separate connection string, and each duplicate of the same source using a different execution warehouse can be displayed on a new page:
Like this for generation, and sources.
Actual behavior
The additional strings which vary only one variable of the string, become duplicate buttons, and factor scales the number of options during generation, creating an unwieldy UI experience.
Steps to reproduce behavior
Add duplicate sources with slightly different connection strings.
Proposed solution
Choice of pages to add connection to (Page 1 sources, page 2....) Or Parameterise the connection string variable and allow for some switch (like rc/drc) between warehouses
(Apologies, I'd love to start on this personally but I'm a little intimidated by the depths of java)