Reloading scripts

Run your load script to export data with the latest data from the data source.

Scripts in the Qlik Cloud Analytics do not run automatically to update their outputs. Reloading the script runs the load script again to load the latest data from the script's data source and then exports it. Script reloads can be manual or scheduled.

For information about which users can reload data, see:

• Managing permissions in shared spaces

• Managing permissions in managed spaces

You can check the reload status of a script. This can be Success, Reloading, or Failed.

• In list view of scripts by clicking the value in the Last modified column.
• In Reload history.

Scheduling reloading script data

You can create a schedule for data reloading in your script. The schedule can be based on frequency, date, and time, or when a dataset in the script is refreshed.

Do the following:

1. Click on the script and select Reload schedule.

2. Click Add schedule.

3. Select any of the time options in Reload the script.

Time-based schedules

When you create a time-based schedule, you can choose:

• The frequency and interval of the reload

• The timezone and time of day

• How long the schedule will be in effect

Repeating reloads can be set at the following intervals:

• Daily: Set the times per day, timezone, and the time of day.

• Weekly: Set the days of the week, times per day, timezone, and time of day.

• Monthly: Set the days of the month, times per day, timezone, and time of day.

• Yearly: Set the months, days of the month, times per day, timezone, and time of day.

By default, schedules will run continuously, with no end date. You can choose to set a start date, an end date, or to only run the schedule between two dates.

Viewing and managing reload schedules

You can view and edit scheduled reloads for all scripts that you own.

To view or edit a reload schedule, in the hub, click on a script, and click Reload schedule.

You can also delete the schedule.

Tenant admins and analytics admins can edit and delete scheduled reload tasks from the Management Console. For more information, see Managing scheduled reloads of script data.

Limitations and considerations

• The reload schedule is disabled if it fails to execute five times in a row. If you own the reload schedule for the script (the reload schedule is assigned to you), you will receive notifications when this happens. Notification settings can be customized for a single script, all scripts in a space, or all scripts in a tenant. For information about the owner of a reload schedule, see Ownership of reload schedules.

• If you have a high number of queued and executing data reload processes (and additional concurrent CPU and memory intensive processes), you might notice that some reload processes execute, in some cases, noticeably after their scheduled start time.

• Scheduled reloads are not included for the published copy of a script. Published scripts must have scheduled reloads reconfigured on the scripts in the managed space.

• If you move a script with a reload schedule between spaces, the reload schedule is deleted. Recreate the schedule in the new space if required.

• If you add or remove datasets in a script with a When a dataset is refreshed schedule, you must remove the schedule and recreate it.

• When using Direct Access gateway to access your data source, reload script queries cannot exceed 500,000 characters.

Ownership of reload schedules

For more information about co-developing script data models, see Collaboratively developing data load scripts in shared spaces.

Manually reloading script data

You can reload a script manually.

Do the following:

• Click on the script and select Reload now.

Viewing reload history for a script

Reload history contains the reload history for the selected script. Use it to help troubleshoot scheduled reload issues. You can view the status, start and end times, and duration of past and current reloads. You can also view and download a corresponding log file.

There are two ways to view the reload history for a script.

• In Overview of a script, click Reload history.
• In the list view of scripts in the hub, click the date in the Last modified column and select View reload history.

On the Reload history page, click the View button to view the reload summary. Optionally, you can also download a detailed log file. When the limit for the number of logs stored is reached, new logs will replace the oldest logs, on a first in, first out basis.

You might want to cancel a reload of your script if the reload is taking too long or the script has been updated with new data and you want to start a new reload. To cancel a reload, go to Reload history, and click Cancel.

You can see the canceled reload in your Reload history.