Analytics SAQL Reference
jNewer Version Available
Identifiers
SAQL identifiers are case-sensitive.
They can be enclosed in single quotation marks (') or no quotation marks.
Quoted identifiers can contain any character that a string can contain.
Unquoted identifiers can’t be a reserved words and must start with a letter (A to Z or a to z) or an underscore. Subsequent characters can be letters, numbers, or underscores. Unquoted identifiers can’t contain spaces.
This example uses valid syntax:
1accounts = load "0Fbxx000000002qCAA/0Fcxx000000002WCAQ";
2opps = load "0Fcyy000000002qCAA/0Fcyy000000002WCAQ";
3c = group accounts by 'Year', opps by 'Year';
4d = foreach c generate opps.Year as 'Year';
5e = filter d by Year == "2002";In the following example, the code in the third line throws an
error:
1accounts = load "0Fbxx000000002qCAA/0Fcxx000000002WCAQ";
2opps = load "0Fcyy000000002qCAA/0Fcyy000000002WCAQ";
3c = group accounts by "Year", opps by "Year";
4d = foreach c generate opps.Year as 'Year';
5e = filter d by Year == "2002";