É possível fazer queries SQL no QVD?

[isadoralmeida06]

Olá,

com um qvd já criado é possivel fazer queries? Por exemplo, select * from qvd_table;

Obrigada

[dplr-rn]

Yes

[isadoralmeida06]

Hi, so I tried doing it, but it gives me an error. It doesn't recognize the SQL statement (select * from qvd_name);

Could you please send me a QVW with an example?

Thank you,

[dplr-rn · Accepted solution]

SQl will not work.
When loading from QVD
LOAD *
FROM YOURPATH\QVD\FACT.qvd (QVD);

[dplr-rn]

check
https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/work-with-...

[isadoralmeida06]

Thanks! That's all I needed to know if Qlik View would accept SQL queries just to fetch some data for quick analyses.

[dplr-rn]

Qlik will accept SQL when accessing database.

[isadoralmeida06]

Ok, gotcha! But my manager wanted to  do queries on the QVD I`ve being generating, but he only knows sql, not qlik syntax. 

[dplr-rn]

You should read up the usefulness of qvds .
Few of which are incremental loads, less strain on db etc