7.2 Release Notes

Single sign-on (SSO) for Reveal, Workbench, and GAdmin with OAuth/OIDC

Added support for remote models and table functions to generate embeddings using those models

New UDF is included to automatically perform RAG across multiple SQL-GPT contexts to choose the relevant contexts and tables when generating SQL

Added KI_HINT_RECURSIVE_EXPLAIN to show operations on materialized view base tables and recursively do the same for base tables that themselves are materialized views in any explain plan. This supports getting an explain plan for a materialized view by executing:

EXPLAIN /* KI_HINT_RECURSIVE_EXPLAIN */ SELECT * FROM my_mview

Added new system-wide, directory, and UDF CREATE permission, as well as CREATE permission for all object types within schemas

Added KI_HINT_NO_SHADOW_CUBE to disable use of the Shadow Cube for caching queries within worker processes

Added support for the following scoped hints:

• KI_HINT_MATERIALIZE
• KI_HINT_GROUPBY_PK
• KI_HINT_NO_VIRTUAL_UNION

Examples:

SELECT /*+ KI_HINT_MATERIALIZE */ *
FROM iter t1 , iter t2
WHERE t1.i < 100 AND t2.i < 100

SELECT /*+ KI_HINT_GROUP_BY_PK / i, COUNT()
FROM iter
GROUP BY 1

SELECT /*+ KI_HINT_NO_VIRTUAL_UNION */ *
FROM
(
    SELECT i FROM iter WHERE i < 100
    UNION ALL
    SELECT i FROM iter WHERE i > 1000 AND i < 2000
)

Added support for KI_HINT_JOB_USER_DATA(user_text) hint for user to provide the query tag that will appear in the Jobs list