Skip to main content Skip to complementary content

Using Data load editor

Create and run data load scripts from the data load editor, and create connections to data sources. When you have loaded the data it is available to the app for analysis.

Click Data load editor under the Prepare tab in the navigation bar to open the data load editor.

Data load editor

Data load editor, with data sources open

Toolbar

Toolbar with the most frequently used commands for the data load editor.

To learn more about the data load script, see Saving the load script, Debugging the data load script and Running load scripts to load data in apps.

History

In History, you can view and manage previous version of your load script.

Managing load script history

Data sources

Add data to your app to your load script.

Add data

Under Add data, you can access the data catalog. The data catalog allows you to load data from all the existing datasets to which you have access. You can load data from multiple datasets at the same time using data catalog.

Loading data from the data catalog

Data connections

Under Data connections you can save shortcuts to the data sources (databases or remote files) you commonly use. This is also where you initiate selection of which data to load. Data connections are sorted by the spaces to which you have access.

For more information, see Loading analytics data and Selecting data in load scripts.

Text editor

You can write and edit the script code in the text editor. Each script line is numbered and the script is color coded by syntax components. The text editor toolbar contains commands for Search and replace, Help mode, Undo, and Redo The initial script contains some pre-defined regional variable settings, for example SET ThousandSep=, that you can optionally edit. For more information, see Modifying regional settings for apps and scripts.

To learn more about script, see Editing load scripts and Script syntax overview.

Sections

Divide your script into sections to make it easier to read and maintain. The sections are executed from top to bottom.

If you have added data using Add data, you will have a data load script section named Auto-generated section that contains the script code required to load the data.

For more information, see Organizing load scripts.

Output

Output displays the autosave status and all messages that are generated during script execution.

Learn more

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!