Analytics SAQL Reference

SAQL Overview
Introduction
Use SAQL in the User Interface
Write Your First Query
Enable SAQL Logs in the Browser
SAQL Basic Elements
SAQL Operators
SAQL Statements
SAQL Functions
Query Performance
PDF

Newer Version Available

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

Write Your First Query

Let's walk through each step of a simple SAQL query.
We’ll create a new dashboard in an Einstein Analytics org. Then we’ll add a simple chart and look at the resulting SAQL.

These steps assume you are using the sample Salesforce Developer org, which includes sample datasets. If you are using a different org, you can still follow the same general steps with your own dataset.

Note

  1. In your Einstein Analytics org, create a new dashboard:
    1. Click Create.
    2. Click Dashboard.
  2. In the window Choose a dashboard template, click Blank Dashboard, then click Continue.
  3. Drag a chart widget to the dashboard canvas.
  4. In the chart widget, click Chart, then select DTC Opportunity dataset.
  5. Click the SAQL Mode button to launch the SAQL editor.
    SAQL Mode button

The SAQL editor displays the SAQL query used to fetch the data and render the chart:

11   q = load "DTC_Opportunity_SAMPLE";
22   q = group q by all;
33   q = foreach q generate count() as 'count';
44   q = limit q 2000;

Let’s take a look at each line in the query.

Line Number Description
1

q = load "DTC_Opportunity_SAMPLE";

This loads the dataset that you chose when you created the chart widget. You can use the variable q to access the dataset in the rest of your SAQL statements.
2 q = group q by all;

In some queries, you want to group by a certain field, for example Account ID. In our case we didn’t specify a grouping when we created the chart. Use group by all when you don’t want to group data.
3 q = foreach q generate count() as 'count';

This generates the output for our query. In this simple example, we just count the number of lines in the DTC Opportunity dataset.
4 q = limit q 2000

This limits the number of results that are returned to 2000. Limiting the number of results can improve performance. However if you want q to contain more than 2000 results, you can increase this number.

You can click Back to go back to the chart. You can use the UI to make modifications to the chart, then view the resulting SAQL.