Specifies the query language to use with Salesforce CRM Analytics.

Possible Values

Data Type

string

Default Value

"SAQL"

Remarks

Salesforce CRM Analytics supports both SAQL and SQL as query languages, each with distinct behaviors.

SQL mode uses standard relational syntax, but some features available in SAQL are not supported. For example, SQL returns a group for null values in grouped queries, while SAQL does not.

If your datasets include date fields, enable the the Index Date Fields in SQL setting in the Tableau CRM UI under Setup > Analytics > Settings > SQL Settings. This setting allows SQL queries to access derived date fields such as year, month, and day components. Datasets must be recreated after enabling the setting for the changes to take effect.