Export data from Qliksense app to AWS S3 bucket

Anoop_Mudholkar — Fri, 02 Apr 2021 08:50:02 GMT

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?

Re: Export data from Qliksense app to AWS S3 bucket

NickBaker — Wed, 04 Mar 2020 12:36:06 GMT

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/Connectors_StorageProvider/Storage%20provider%20connectors/Amazon-S3-storage-provider-connector.htm

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!

topic Export data from Qliksense app to AWS S3 bucket in Connectivity & Data Prep

Export data from Qliksense app to AWS S3 bucket

Re: Export data from Qliksense app to AWS S3 bucket