Export data from Qliksense app to AWS S3 bucket

[Anoop_Mudholkar]

Hi,

How can I create a data pipeline to export Qliksense app data directly to AWS S3 using a python script? 

Can we use the S3 web connector? If yes, how?

[NickBaker]

Hi if you are using Qlik Sense Business you can use the S3 connector - the docs are here and are still evolving: https://help.qlik.com/en-US/connectors/Subsystems/Web_Storage_Provider_Connectors_help/Content/Conne...

You can store to an S3 bucket directly from script, here is a simple example that loads some test data from S3 and then stores it back to S3:

TestData:
LOAD *
FROM [lib://Amazon_S3/some/path/someFileToDownload.csv]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);
STORE TestData into [lib://Amazon_S3/some/path/someFileUploaded.csv] (txt);

Remember to update to use your actual S3 connection name which in this example is 'Amazon_S3'.

Hope this helps!