Toggle Side Panel
Close search

Activity › Forums › Salesforce® Discussions › What is SAQL in Salesforce?

Tagged: , , , , , , ,

  • 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.

     

     

  • [adinserter block='9']

  • 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.

Log In to reply.