Skip to main content

Official Support Articles

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST

How to Export Data from Qlik Catalog to Cloud Storage

cancel
Showing results for 
Search instead for 
Did you mean: 
KellyHobson
Support
Support

How to Export Data from Qlik Catalog to Cloud Storage

Introduction

In this example, we'll go over how to export CSV files from Qlik's Catalog into cloud storage.

Qlik has multiple cloud storage connectors, including, but not limited to Amazon S3, Azure Storage and Google Cloud Storage.

Follow the steps below to export your data from inside Qlik to your cloud storage.

 

Steps

  1. The first step is to log in to your Qlik tenant
  2. Next, create a "New analytics app".

    1.png

  3. In your new analytics app, go to the "Data load editor." This can be done by clicking on the drop down which can be found at the top right of your screen.

    2.png

  4. Create a new "Section." Do this by clicking on the "+" button in "Sections" pane. The pane can be found at the left of your screen.

    3.png

  5. Next up is to create a connection. This connection will allow you to connect to your cloud storage. To do this, click on the "Create new connection" button, choose a supported cloud storage connector of your choice, fill in the credentials and authenticate. For the purposes of this example, we'll use Google Drive to store our CSV file, but you're welcome to choose from the various connectors supported by Qlik

    4.png

    After establishing a connection, it should show up in the connections pane, which can be found at the right side of your screen.

    5.png

  6. Load the data from the data catalog. To do this, click on the "Add from data catalog" button at the top right of your screen. Select the CSV you wish to export. Click "Next" and then click "Insert script". You should now see the "LOAD" script in your scripting pane.

    6.png
    Your script should look like this:

    LOAD
        id,
        chats,
        message,
        churn,
        amount
    FROM [lib://DataFiles/test_data.csv]
    (qvd);

  7. Assign this "LOAD" script to a variable to be able to use it in the "STORE" script. To do that, at the top of the "LOAD" script insert the variable name in square brackets. For this example, we'll name our variable "data".

    Your script should now look like this:

    [data]:
    LOAD
        id,
        chats,
        message,
        churn,
        amount
    FROM [lib://DataFiles/test_data.csv]
    (qvd);

  8. Create your "STORE" script.

    Note: Before continuing with this step, it would be easier if there already exists a CSV in your cloud storage which can be used as a placeholder. If it doesn't exist, simply place an empty CSV to be the placeholder. Make sure the CSV is in the folder to where you wish to export your script.

    This is the part where we export our data to the cloud storage. Click on the "Select data" icon under your cloud storage connection in the connections pane and select the placeholder CSV and then click "Insert script". This should give you a "LOAD" script. We'll replace "LOAD <columns> FROM" with "STORE [data] INTO". We'll also rename the file name and replace the last bit between parentheses with a semi-colon ( ; )

    7.png

    The export script should look like the following:

    STORE *
    FROM [data]
    INTO [lib://Google_Drive - email@qlik.com/randomgeneratedvalue/test_data_export.csv];

    Your final script should look like the following:

    [data]:
    LOAD
        id,
        chats,
        message,
        churn,
        amount
    FROM [lib://DataFiles/test_data.csv]
    (qvd);

    STORE *
    FROM [data]
    INTO [lib://Google_Drive - email@qlik.com/randomgeneratedvalue/test_data_export.csv];


    And this is how it all comes together.

    8.png

  9. Now that all the script is set up, the last step is to hit the "Load data" button at the top right of your screen.

    9.png

    Your data should now be in your cloud storage.

 

 

Environment

 

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

 

Version history
Last update:
‎2022-11-16 04:57 AM
Updated by: