Improvements to SCV SQL previewer and Interface Service preview

It is now possible to cancel long-running queries in SQL Previewer and Interface Service previews. In addition, a timeout is also implemented to stop the execution of long-running queries to prevent performance degradation, for example, in cases of unexpectedly large data volumes in queried tables or join errors in queries.

Hints are frequently used when querying the Data Lake using the Compass driver. Previously, hints are supported only when an interface service on the Data Lake is executed. Now the specified hints are also used when previewing the query results in the interface service.

SCV configuration parameters are now accessible from SCV SQL Previewer. The same format as SCP parameter variables, namely %scv_config_ParamName%, is used to reference SCV configuration parameters from SQL Previewer queries. At run time the variable is replaced with the actual parameter value as specified in SCV.

Example, %scv_config_SCP_CURRENCY%

Note: This feature is available on update. You are not required a new role or privilege access to use this feature.