![]() ![]() Keywords are case-sensitive and must be lowercase.The only exception is the last line in a query, which doesn’t have to be assigned explicitly. Assign each query line to an identifier called a stream.Statements can span multiple lines and must end with a semicolon. A statement is made up of keywords (such as filter, group, and order), identifiers, literals, and special characters.Q = foreach q generate sum('Amount') as 'sum_Amount' Each SAQL statement has an input stream, an operation, and an output stream. A SAQL query loads input data, operates on it, and outputs the result data.Analytics uses SAQL behind the scenes in lenses, dashboards, and explorer to gather data for visualizations. ![]() Use SAQL (Salesforce Analytics Query Language) to access data in Analytics datasets. Transformations During Data Flow: Use SAQL to perform manipulations or calculations on data when bringing it in to Analytics.Compare Table: Use SAQL to perform calculations on data in your tables and add the results to a new column.A dashboard is a curated set of charts, metrics, and tables. Dashboard JSON: Create advanced dashboards.Analytics REST API: Build your own app to access and analyze Analytics data or integrate data with existing apps.Developers can write SAQL to directly access Analytics data via: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |