Proactive query performance safeguards for Data Hub

• Default On

Who: BI Analysts, Customer Admins, Talent Admins

Requirements: Write optimized SQL queries and avoid running unoptimized ones. This feature improves query execution performance and delivers faster outputs.

What's new: This feature introduces a technical foundation that leverages database-native EXPLAIN commands to estimate query data scans before execution. It enables proactive resource protection by preventing unoptimized or 'runaway' queries from consuming excessive compute. This ensures system stability and provides a better user experience by blocking queries that would otherwise lead to timeouts or performance degradation.

How it works: When a user initiates a query, the platform runs a pre-execution check using the database's execution plan to estimate how much data will be scanned and how long the query will run. If the estimated runtime exceeds a predefined threshold, the system blocks the query and surfaces an error message to the user.

Value: Improved system performance