What is SAQL in Salesforce?

Tagged: Analytics Cloud, Dashboard, Data Integration, Data Sets, JSON, Rest API, Salesforce Analytics Query Language, SAQL

Salesforce® Discussions

What is SAQL in Salesforce?

Posted by shradha jain on August 28, 2018 at 7:02 am

What is SAQL in Salesforce?

shariq replied 6 years, 5 months ago 5 Members · 4 Replies
4 Replies

madhulika shah

Member
August 28, 2018 at 7:05 am
Hi Shradha,

SAQL (Salesforce Analytics Query Language) is used 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 Cloud data via:
- Wave REST API: Build your own app to access and analyze Analytics Cloud data or integrate data with existing apps.
- Dashboard JSON: Create advanced dashboards. A dashboard is a curated set of charts, metrics, and tables.
Prachi

Member
September 17, 2018 at 1:28 pm

Hi,

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.

thanks.
Parul

Member
September 17, 2018 at 1:46 pm
This is new Query language for Analytics cloud to enable ad hoc analysis of data stored in dataset. SAQL is compositional and you can chain statements together to operate on data sequentially. The order of SAQL statements is enforced according to how the operations in the statements change the results of a query.

The statement order rules:
- The order of filter and order can be swapped because it doesn't change the results
- offset must be after filter and order
- offset must be before limit
- There can be no more than 1 offset statement after a foreach statement
Thanks
shariq

Member
September 18, 2018 at 11:45 pm

Hi,

Adding more point to it -

Introduction
Most actions you take in Analytics result in one or more SAQL queries. Every lens, dashboard, and explorer action generates and executes a SAQL statement to build the data needed for the visualization.
Use SAQL in the User Interface
Use the Analytics Studio user interface to modify existing SAQL queries or write new ones. Writing SAQL queries in the user interface is the easiest way to get started.
Write Your First Query
Let's walk through each step of a simple SAQL query.
Enable SAQL Logs in the Browser
If you’re using Google Chrome to work with SAQL and Einstein Analytics, you can turn on SAQL logs

Hope this helps.