---
schema_version: "1"
id: 6e762c3435823dd6d25f175309988b98812a7164703793bcf9dd83e6b1d4127d
title: Migrate CRM Analytics Queries to Data 360 SQL (Beta)
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_migrate_queries_to_data360_sql.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_migrate_queries_to_data360_sql.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 9aa6f31083fca3beaf848b66b54901fa4caa818752694b5614f8f3bd9fc10392
description: 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.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# 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

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Essentials</strong>, <strong>Group</strong>, <strong>Professional</strong>, <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d79104e82">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d79104e82 ">To manage the SQL version of queries in lenses and widgets.</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d79104e82 ">Create and Edit CRM Analytics Dashboards</td>

          </tr>
        </tbody>
      </table>

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note This feature is a pilot or beta service that is subject to the Beta Services Terms at [Agreements - Salesforce.com](https://www.salesforce.com/company/legal/) or a written Unified Pilot Agreement if executed by Customer, and applicable terms in the [Product Terms Directory](https://ptd.salesforce.com/). 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](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_query_mode_icon.png) .
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.

- **[Considerations, Guidelines, and Limitations for Data 360 SQL Migration (Beta)](https://help.salesforce.com/s/articleView?id=analytics.bi_data_sql_considerations_limitations.htm&release=264.0.0&type=5)**  
    Keep these considerations, guidelines, and limitations in mind when migrating custom SQL queries to Data 360 SQL.

#### See Also

- [Data 360 SQL Reference](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/data-cloud-sql-context.html)
- [Data 360 SQL Syntax](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/sql-commands-context.html)