One of the test plans in BI Validator leverages the Usage Tracking table to compare the query metadata. Below are the details.

Usage Tracking Database :

Tables:

S_NQ_ACCT

S_NQ_DB_ACCT

Columns:

SUBJECT_AREA_NAME

QUERY_TEXT

QUERY_BLOB

Query:

SELECT A.SUBJECT_AREA_NAME AS SUBJECT_AREA,B.QUERY_TEXT,B.QUERY_BLOB FROM S_NQ_ACCT A,S_NQ_DB_ACCT B WHERE A.QUERY_SRC_CD=' QuerySrcId ' AND A.ID=B.LOGICAL_QUERY_ID

Permissions needed for the user :

SKIP_PHYSICAL_QUERY_EXEC=1,DISABLE_CACHE_SEED=1,DISABLE_CACHE_HIT = 1,LOCALE='en-US'