February 21st, 2022
Post Cover Image

Snowflake Role and Warehouse Choosers

When running queries against Snowflake, it can be useful to change the warehouse you are executing against, or the role you are using. Previously, you could set these values at the connection level, where this meant you would have to make a new connection for each warehouse or role you wanted. We have released a new update where these options can now be changed on the fly via dropdowns under the "Run" button in the query editor, similar to the existing database option. On changing your role, we will automatically refresh the available warehouse list to help prevent trying to use a warehouse that a given role does not have access to. The fetched schema for the connection will continue to use the originally set warehouse and role, but we are looking into making this also adjust to using the adhoc selected role as well in the future. This is immediately available to all customers for both direct and cloud connections, and the chosen role, warehouse, and database are all set on a per query basis.

Other Fixes & Improvements

  • Fix running queries ending with semi-colons in Presto
  • Performance improvements for admins of organizations with several thousand queries
  • Fix "empty url" error on trying to connect with Azure cloud connections
  • Fix z-index style bug for some dropdowns of popovers
  • Creating a new dashboard in shared folder will have it be properly shared from the onset
  • Add carets to dropdowns beneath the Run button to better indicate they are changeable
  • Open number chart color filter dropdown above instead of below field
  • Show full number unless precision is non-zero for big number charts. If precision is non-zero, then the number will be rounded and show K, M, etc. for large numbers
  • Allow using CMD/CTRL+# to move between tabs for 0-8, and CMD/CTRL+9 will always open the last tab
  • Fix bug where SHIFT+CMD/CTRL+Z would open dbt panel instead of trigger redo in editor. Keyboard shortcut for opening dbt panel is now SHIFT+CMD/CTRL+U
  • Fix case where we were not properly analyzing queries run against direct connections for use in data catalog and popularity statistics

Ready for a modern SQL editor?