Loading
Salesforce now sends email only from verified domains. Read More
CRM Analytics
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
            Migrate CRM Analytics Queries to Data 360 SQL (Beta)

            You are here:

            1. Salesforce Help
            2. Docs
            3. CRM Analytics

            Migrate CRM Analytics Queries to Data 360 SQL (Beta)

            Data 360 SQL provides improved data handling, larger result sizes, and better scalability. New compact form queries and custom SQL queries now run on Data 360 SQL by default. Existing custom SQL queries continue to use legacy SQL, and can be switched manually to Data 360 SQL for improved performance.

            Required Editions

            Available in: Lightning Experience
            Available in: Essentials, Group, Professional, Enterprise, Performance, Unlimited, and Developer Editions
            User Permissions Needed
            To manage the SQL version of queries in lenses and widgets. Create and Edit CRM Analytics Dashboards
            Note
            Note This feature is a pilot or beta service that is subject to the Beta Services Terms at Agreements - Salesforce.com or a written Unified Pilot Agreement if executed by Customer, and applicable terms in the Product Terms Directory. Use of this pilot or beta service is at the Customer’s sole discretion.
            1. From the App Launcher, find and select Analytics Studio.
            2. Click Browse, and then click Lenses.
            3. Select a lens that contains a custom SQL query written in the Legacy SQL version.
              To check the SQL version, navigate to the step details or step properties panel of the lens, and check if the SQL version is Legacy SQL.
            4. In the lens explorer, click the Query Mode icon Query mode icon .
            5. To change the SQL version to Data 360 SQL, click the SQL Version dropdown and select Data 360 SQL.
            6. Review the instructions in the confirmation window and click Change to Data Cloud SQL.
            7. Click Update.
              The SQL version of the custom SQL query is changed to Data 360 SQL.

            To verify if your query is changed to Data 360 SQL, go to the Advanced Interaction Editor, and check if the useLegacyCdpQueryApi property is set to false. This implies that your query is using the Data 360 SQL version.

            See Also

             
            Loading
            Salesforce Help | Article