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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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