---
schema_version: "1"
id: 120e99cdb1e9eff5637d25812958cbf4f344f10fff615f00a643f1f4f4d2e9e1
title: Use the Granular Data Center to Pull Data 360 Data into Intelligence
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_data_connect_api_cdp_gdc.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_data_connect_api_cdp_gdc.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 03d0ec070284434ff16351491e8e98cb0bc4ba6745d19034c865adfbf6c5785e
description: To analyze a lot of data, use the Granular Data Center connector to pull in your data. You can query up to 15 million rows at one time.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Use the Granular Data Center to Pull Data 360 Data into Intelligence

To analyze a lot of data, use the Granular Data Center connector to pull in your data. You can query up to 15 million rows at one time.

### Required Editions

<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="d81948e41">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d81948e41 ">To create a data stream in <span>Data 360</span>:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d81948e41 "><span>Data Cloud Architect</span></td>

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

When querying large amounts of data, you might not receive all the results on the same day. For instance, ingesting 100 million rows requires running 2,000 queries, takes 2 days. For Query API and Insights API Corporate and Enterprise editions, you can run up 1,000 daily queries. However, due to Data 360 functionality, only 50,000 rows can be fetched per query.

You must have the Granular Data Center add-on. For more information, contact your Marketing Cloud Intelligence representative.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/images/icon_note.png)

Note You must first set up access from Data 360 to Marketing Cloud Intelligence before you can connect your data. For more information, see [Set Up Access to Pull Data 360 Data](https://help.salesforce.com/s/articleView?id=mktg.dato_data_connect_cdp_prerequisites.htm&release=264.0.0&type=5 "Before you can pull in data from Data 360 into Marketing Cloud Intelligence, authenticate access between the apps.")

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/images/icon_note.png)

Note Make sure you have at least one data stream defined in Data 360 before connecting Marketing Cloud Intelligence.

1. On the Connect and Mix tab, under the Granular Data Center, select **Granular Data Center Streams**.
2. Click **Add New**.
3. Click **Technical Vendor**, and select **Salesforce Data Cloud**.
4. Select **Databases** as the delivery method.
5. Enter your Data 360 username and password.
6. Write your SQL query.
    
    For example, `select * from ssot__Individual__dlm limit 2` queries two rows of all the columns in your data model object. Limiting the query to two rows gives quick results.
7. To view a summary of your query result, click **Evaluate**.
8. To confirm your credentials and verify your data, click **Validate**.
9. Specify how often to run the query.
10. Save the query.
11. After the data is loaded, click **Create**.

A new data stream is created and you can now analyze your Data 360 data.

#### See Also

- [Enable the Granular Data Center in a Workspace](https://help.salesforce.com/s/articleView?id=mktg.dato_data_lakes_enable.htm&release=264.0.0&type=5 "Purchasing the Granular Data Center automatically enables it in the account. However, an admin must enable it in the workspace. If it isn’t enabled, the Granular Data Center tab doesn’t appear.")
- [Use TotalConnect to Pull Data 360 Data into Intelligence](https://help.salesforce.com/s/articleView?id=mktg.dato_data_connect_api_cdp_totalconnect.htm&release=264.0.0&type=5 "If you have Data 360 data and you want to bring it into Marketing Cloud Intelligence, you can use the TotalConnect connector. With this connector you can fetch up to 50,000 rows per query and run up to 1,000 queries per day. After you connect your data, a data stream is created and you can then get insights on your data.")