---
schema_version: "1"
id: 368a0f45c00ed8a4c43d2c868c542e31ecd02bc347f23c902b576a26b43b12ad
title: Granular Data Center Query Limitations
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_data_lakes_query_limitations.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_data_lakes_query_limitations.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 5b1fe15c7767955829c1a7552647c30fd7b432139a6252dd5983df724218f649
description: There are two tools you can use to create queries, the query builder and SQL. SQL should be used for more complex use cases. If you experience any limitations with the preview or downloading your data, consider the export or schedule export options.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Granular Data Center Query Limitations

There are two tools you can use to create queries, the query builder and SQL. SQL should be used for more complex use cases. If you experience any limitations with the preview or downloading your data, consider the export or schedule export options.

This table presents the different actions and their limitations:

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
      <colgroup>
        <col style="width:50%">
        <col style="width:50%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d86961e39">Action </th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d86961e42">Limitation</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d86961e39 ">UI Preview</td>

          <td data-label="Limitation" class="slds-cell-wrap" style="vertical-align:top;" headers="d86961e42 ">
            <p>Timeout: 3 Min</p>
            <p style="margin-bottom:0;">Returned Rows: 5,000</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d86961e39 ">Download</td>

          <td data-label="Limitation" class="slds-cell-wrap" style="vertical-align:top;" headers="d86961e42 ">Returned Rows: 25,000</td>

        </tr>
        <tr class="">
          <td data-label="Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d86961e39 ">Export to</td>

          <td data-label="Limitation" class="slds-cell-wrap" style="vertical-align:top;" headers="d86961e42 ">
            <p>File Formats: PARQUET, ORC, CSV, and CSV Friendly Formatting</p>
            <p style="margin-bottom:0;">CSV Friendly Formatting
              is limited to 2.3M rows in the results.</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d86961e39 ">Scheduled Export</td>

          <td data-label="Limitation" class="slds-cell-wrap" style="vertical-align:top;" headers="d86961e42 ">
            <p>File Formats: PARQUET, ORC, CSV, and CSV Friendly Formatting</p>
            <p style="margin-bottom:0;">CSV Friendly Formatting
              is limited to 2.3M rows in the results.</p>
          </td>

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