What is a Salesforce Analytics Query Language (SAQL)?

Hi Prachi,

You can use SAQL (Salesforce Analytics Query Language) to access data in Analytics Cloud datasets.
Analytics Cloud uses SAQL behind the scenes in lenses, dashboards, and explorer to gather data for visualizations. Users don’t write SAQL statements, they use the UI and the app makes the queries.

Developers can write SAQL to directly access Analytics data via:

• Analytics REST API :Build your own app to access and analyze Analytics data or integrate data with existing apps.
• Dashboard JSON :Create advanced dashboards. A dashboard is a curated set of charts, metrics, and tables.

Use SAQL (Salesforce Analytics Query Language) to access data in Analytics datasets. Analytics uses SAQL behind the scenes in lenses, dashboards, and explorer to gather data for visualizations.

Developers can write SAQL to directly access Analytics data via:

·         Analytics REST API

Build your own app to access and analyze Analytics data or integrate data with existing apps.

·         Dashboard JSON

Create advanced dashboards. A dashboard is a curated set of charts, metrics, and tables.

The logical layers a query passes through

Sample Query

1   q = load “DTC_Opportunity_SAMPLE”;

2   q = group q by all;

3   q = foreach q generate count() as ‘count’;

4   q = limit q 2000;