Documentation
Toggle Dark/Light/Auto modeToggle Dark/Light/Auto modeToggle Dark/Light/Auto modeBack to homepage

Release Notes

2024-10-03

  • Optimised memory usage for pin refresh with large queries.
  • Fixed token refresh validity and propagated Snowflake error correctly.
  • fixed Gant Chart Plugin showing lanes for non-existent data.
  • Fixed wrong order in variables for dynamic sql in autorouting task.
  • Broker internal queries are now automatically retried in case of 5xx errors from Snowflake and do not generate a user-facing error if they succeed on retry.
  • Improved error messages for invalid definition of network policy.
  • More statistics were added for pinned tables.
  • Private results feature was deprecated, use private broker instead. See https://docs.sundeck.io/advanced/private-broker/ for details.
  • Improved error message in cases where connection to NativeApp was attempted with disabled Snowflake user.
  • Removed erroneous message in UI requiring plan upgrade on attempt to grant permissions to the user.
  • Imporved NativeApp main langing page.
  • Autorouting improvements:
    • New DDL statement SUNDECK$ENABLE_AUTOROUTING_SHARE was introduced to ease customer sharing for autorouting information with Sundeck support.
    • improvements to learning algorithms and minor changes to the autorouting model.
    • fall back to default warehouse size in the pool in case when auto-routing algorithm generated invalid value for warehouse size.
  • It is no longer possible to use SQL_QLIKE/SQL_MATCHES conditions in the broker hooks.

2024-09-05

  • Support for Network Policies is now available. For configuration details, see https://docs.sundeck.io/reference/ddl/create-sundeck-flow/
  • Template substitution for a sql statement using jinja2-like templating syntax based on Django is now available as part of experimental feature (see ‘Templating Engine (Experimental)’ pre-hook in the Broker UI section)
  • Billing subscriptions are enforced now
  • When snowflake user is disabled correct error message is displayed on the Connection screen.

2024-08-22

  • Columns where renamed to be more descriptive in REPORTING.AUTOROUTING_HISTORY view.
  • New column WAREHOUSE_POOL was added to REPORTING.AUTOROUTING_HISTORY view.
  • Improved scaling down of a warehouse in autorouting model.
  • Autorouting model behavior was updated to consider all query instances that match targeted hash.
  • String values in the column REPORTING.AUTOROUTING_HISTORY.TARGET_WAREHOUSE_SIZE are now matching those in SNOWFLAKE.QUERY_HISTORY.WAREHOUSE_SIZE.
  • Fixed an error when ALTER SUNDECK VIEW PIN=TRUE REFRESH_FREQUENCY_SECONDS=60; was executed for the first time.
  • Improved performance of signup
  • Token type for the NativeApp was renamed from OPSCENTER to NATIVE_APP, see https://docs.sundeck.io/reference/ddl/show-sundeck-tokens/
  • Users now can change subscription type on the Billing page
  • Known query routing and autorouting hook don’t route USE ROLE statements

2024-08-08

  • NativeApp health report is available.

2024-08-01

  • Billing service is enabled now.

2024-07-23

  • Fixed an issue in the replace tables hook were comments were not carried through.
  • New option in SHOW SUNDECK FLOWS TERSE=TRUE
  • Disallow dropping pin table when in use.
  • Allow side nav items to open tab.
  • SHOW SUNDECK LABELS returns correct error message now.
  • Fixed cryptic ‘Operation not supported’ error while trying to connect to private broker with missing accountId.
  • Enhance private broker to support SSL termination.
  • Querying views BROKERS, PINS, ROUNTINES in schema CATALOG incorrectly required ADMIN grant.
  • New column ROUTINE_HOOKS was added to the output of SHOW SUNDECK ROUTINES and new column HOOKS added to SHOW SUNDECK FLOWS. These columns expose hooks in json format.

2024-07-15

  • DESCRIBE_ONLY boolean column was added to OPSCENTER.REPORTING.SUNDECK_QUERY_HISTORY to indicate whether query is describe only.
  • When Snowflake SSO is enabled, user is not allowed to change connection to a different Snowflake account in the UI until SSO is disabled. To disable SSO please see https://docs.sundeck.io/reference/ddl/sundeck-disable_snowflake_sso
  • Linking of NativeApp to private broker is allowed now. This can be achieved by running SELECT SUNDECK$LINK_NATIVE_APP()
  • Account Settings page information can now be found on Connections page.

2024-07-08

  • Fixed missing grant CREATE WAREHOUSE ON ACCOUNT TO APPLICATION SUNDECK in the help text.
  • Columns added to REPORTING.SUNDECK_QUERY_HISTORY view: SUNDECK_ACCOUNT_ID, DESCRIBE_ONLY, DESCRIBE_STATUS, DESCRIBE_ERROR.
  • Better error message when slack appplication is not linked to Sundeck tenant.
  • Excluded warehouse pools from account peak credit usage and noted in the help text that peak credits information is refreshed once an hour.
  • DESCRIBE_STATUS and DESCRIBE_ERROR columns were added to SUNDECK_QUERY_HISTORY for describe only queries.
  • Improvements for Connection Form: key/pair authentication is a default method now.
  • Improved performance of NativeApp linking.
  • Restore space between elements on ConnectionForm.

2024-07-01

  • SUNDECK_ERROR_CODE is correctly populated now in SUNDECK.REPORTING.QUERY_HISTORY when Sundeck DDL fails with an error.
  • Background task to clean up unused pinned tables and associated views and tasks in Native App was added.
  • Invalid warehouse pools configuration was throwing HTTP 500 error.
  • Bin Animation improvements:
    • don’t show tooltips for nodes that have disappeared
    • fixed label positions
    • hide tooltip when blurring the window
  • Improved error messages during linking of Native App. Instead of generic error, Snowflake specific error messages are returned.