Analytics SAQL Developer Guide

Overview
Quick Start
Examples
SAQL Reference
SAQL Basic Elements
SAQL Operators
SAQL Statements
arimax
cogroup
fill
filter
foreach
group-by
group-by rollup
join semi and anti
limit
load
offset
order
sample
timeseries
union
SAQL Functions
Query Performance
PDF

Note: This release is in preview. Features described here don’t become generally available until the latest general availability date that Salesforce announces for this release. Before then, and where features are noted as beta, pilot, or developer preview, we can’t guarantee general availability within any particular time frame or at all. Make your purchase decisions only on the basis of generally available products and features.

load

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

Syntax

1result = load dataset;

If you’re working in Dashboard JSON, dataset must be the dataset name from the UI. Use of the dataset name (also called an alias) means the app can substitute it with the correct version of the dataset.

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

Usage

After being loaded, the data is not grouped. The columns are the columns of the loaded dataset.

Example

Load the Accounts dataset to the stream 'b'.

b = load "Accounts";