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 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.
- From the App Launcher, find and select Analytics Studio.
- Click Browse, and then click Lenses.
-
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.
-
In the lens explorer, click the Query Mode icon
.
- To change the SQL version to Data 360 SQL, click the SQL Version dropdown and select Data 360 SQL.
- Review the instructions in the confirmation window and click Change to Data Cloud SQL.
-
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.
- Considerations, Guidelines, and Limitations for Data 360 SQL Migration (Beta)
Keep these considerations, guidelines, and limitations in mind when migrating custom SQL queries to Data 360 SQL.