Wave Analytics SAQL Reference

SAQL Overview
Enable SAQL Logs in the Browser
SAQL Basic Elements
SAQL Operators
SAQL Statements
load
filter
foreach
group and cogroup
union
order
limit
offset
SAQL Functions
PDF

Newer Version Available

This content describes an older version of this product. View Latest

load

Loads a dataset. All SAQL queries start with a load statement.

Syntax

1result = load dataset;

If you’re working in Dashboard JSON, dataset can be either the containerId/versionId or the dataset name from the UI. It’s a good idea to use the dataset name (also called an alias) because the app substitutes it with the correct version of the dataset.

If you’re working in Wave REST API, dataset must be the containerId/versionId.

Usage

After being loaded, the data is in ungrouped form. The columns are the columns of the loaded dataset.

Example

The following example loads the dataset with ContainerID “0Fbxx000000002qCAA” and VersionID “0Fcxx000000002WCAQ” to a stream named “b”:

b = load "0Fbxx000000002qCAA/0Fcxx000000002WCAQ";

Example

The following example loads the dataset with the name “Accounts” to a stream named “b”:

b = load "Accounts";