Tableau CRM SAQL Developer Guide

Overview
Quick Start
Examples
SAQL Reference
SAQL Basic Elements
Statements
Keywords
Identifiers
Number Literals
String Literals
Boolean Literals
Multivalue Field
Quoted String Escape Sequences
Special Characters
Comments
SAQL Operators
SAQL Statements
SAQL Functions
Query Performance
PDF

Newer Version Available

This content describes an older version of this product. View Latest

Identifiers

SAQL identifiers are case-sensitive and must be enclosed in single quotation marks (').

Identifiers that are enclosed in quotation marks can contain any character that a string can contain.

This example uses valid syntax: 
1q = load "Opportunity";
2
3--'Stage' is enclosed in single quotes because it is a field. "08 - Closed Won" is enclosed in double quotes because it is a string.
4q = filter q by 'Stage' == "08 - Closed Won";
5q = group q by 'Account_Owner';
6q = foreach q generate 'Account_Owner' as 'Account_Owner', count() as 'count';

This example is not valid because you can't use double quotes for an identifier.

1--this should be 'Account_Owner' in single quotes
2q = group q by "Account_Owner";