How to export data via Store Statement

[yildirimkdata]

Dear all,

the script below works and I can see the data when I click the 'analyze sheet' section. However, it does not export the data into the selected folder via store statement. Can someone help me about that? (Data is ca 3 million rows, thus I can't export it as excel and want to export as csv.)

LIB CONNECT TO 'sales_Snowflake_Azure';

LOAD SALES, 

SALETYPE, 

SALEDATE, 

ORGANISATION, 

PRICE, 

CURRENCY;

[SALES]:

SELECT "SALES",

"SALETYPE",

"SALEDATE",

"ORGANISATION",

"PRICE",

"CURRENCY"

FROM "text"."TEXT_TEXT"."SALES" WHERE YEAR(SALEDATE) = 2022;

STORE [SALES] INTO [C:\Users\Arigha\Downloads\sales_data.csv] (txt);

[vincent_ardiet_ · Accepted solution]

By default, you cannot access to a folder directly in Qlik Sense.
You need to use a LIB: ressource, so you will have to create the data connection to this folder first. 
Else you will need to change the settings in the QMC to allow this but this could be dangerous if some users can make their own reports as they will have access to all folders accessible via your service account.

[yildirimkdata]

many thanks!