A query with a simple select that works in regular SQL doesn't in Direct Query. The rror message shown is: ERROR [02000] SQL compilation error: "`DB_NAME`" does not exist or not authorized.
Error Message
Query used: DIRECT QUERY DIMENSION JOB_ID MEASURE STATUS FROM "GRAY_DB"."JOBPOSTINGS_2_SCHEMA"."SOC_DECANARIA_RESULTS";