Data 360: Query Syntax

1. Object or Field Name
Use " " or nothing.

SELECT * FROM EmailActivity_0Uvxxxx__dll WHERE "eventType__c" <> 'OPEN' LIMIT 10

2. String match - Text field

Use ' ' and case-sensitive

SELECT * FROM EmailActivity_0Uvxxxx__dll WHERE "eventType__c" <> 'OPEN' LIMIT 10

3. Filter on Boolean field

SELECT * FROM ssot__Individual__dlm  WHERE "Is_FieldName__c" IS NOT TRUE LIMIT 10

OR

SELECT * FROM ssot__Individual__dlm  WHERE "Is_FieldName__c" IS TRUE LIMIT 10

4. Filter on Text field

SELECT * FROM "ssot__Account__dlm" WHERE "Customer__c" <> '' LIMIT 10

OR

SELECT * FROM "ssot__Account__dlm" WHERE "Customer__c" = '' LIMIT 10

5. Filter on DateTime field

SELECT

    l."Status__c" AS Lead_Status,

    COUNT(DISTINCT l."Id__c") AS Total_Leads,

    COUNT(

        DISTINCT CASE

            WHEN e."createdAt__c" >= TIMESTAMP '2026-05-01 00:00:00'

             AND e."createdAt__c" <= TIMESTAMP '2026-05-31 23:59:59'

             AND e."sendStatus__c" = 'SENT'

            THEN l."Id__c"

        END

    ) AS Contacted_May_2026

FROM "Lead_Home__dll" l

LEFT JOIN "EmailActivity_0Uvxxxx__dll" e

    ON l."Id__c" = e."prospectSalesforceId__c"

GROUP BY Lead_Status

ORDER BY Lead_Status;