Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
JulioArriagaDerevo
Partner - Contributor II
Partner - Contributor II

Simple Query doesn't work with Direct Query

Hi, 

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 MessageError Message

Query used:
DIRECT QUERY
DIMENSION
JOB_ID
MEASURE
STATUS
FROM "GRAY_DB"."JOBPOSTINGS_2_SCHEMA"."SOC_DECANARIA_RESULTS";

Full Error MessageFull Error Message

Success of a simple query:

Simple Query WorkingSimple Query Working

 

 

Labels (2)
0 Replies