Loading
Salesforce now sends email only from verified domains. Read More
Einstein and Analytics in Marketing Cloud Engagement
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Query Your Data with SQL

            You are here:

            1. Salesforce Help
            2. Docs
            3. Engagement: Einstein and Analytics

            Query Your Data with SQL

            You can create queries manually using an SQL editor. You can also use or modify one of the predefined queries in the Query Library. These represent commonly used queries in Query Builder and SQL formats.

            Required Editions

            Available in: Intelligence Reports Advanced
            Note
            Note The syntax used in SQL queries is Presto SQL.
            1. On the Queries tab, click Create New Query.
            2. Name your query.
            3. Select SQL, and click Create.
            4. Write your query.

              queries sql panel

              1. Create your query (1) and then run (2) it to view the results.
              2. You can save your query (4) and view it later in the Query Library (5).
              3. You can download or export your query results (6) and perform scheduled exports on saved queries.

            To use SQL Queries most efficiently:

            • To wrap a value in quotes, highlight the value and then type “ ‘ “
            • To run only a portion of the query in the SQL window, highlight the section and then click Run.
            • To copy the value of a cell in the results, right-click the cell and click Copy.
             
            Loading
            Salesforce Help | Article