If you don't understand why the title is referring to 101. Please have a quick look at this article
The idea of this course is to help everyone understand the basics of SAQL queries and help them write their own SAQL queries.
When I saw the SAQL syntax for the first time It reminded me of the pig script syntax. But when I started building them this myth got busted and SAQL is something syntactically and semantically unique.
A statement is made up of keywords (filter, group, & order), identifiers, literals, and special characters.
Statements can span multiple lines and each line is called a stream
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
They are case-sensitive and sometimes enclosed in single quotation marks
- Arithmetic Operators
- Comparison Operators
- Logical Operators
- Null Operators
If you are coming from a programming background these operators work similar, If you want more information to refer to the Analytics SAQL Reference
- group & cogroup
- Aggregate Functions
- Date Functions
- String Functions
- Math Functions
- Windowing Functions
You can refer to this article on how to enable browser logs for SAQL