---
schema_version: "1"
id: 167f4bec8914becb949dddd6a2588941b79da9c0586eecb1d356accc236d6682
title: Query Limitations
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_dat_queries_limits.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_dat_queries_limits.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 398c8cf35a6ac8224e3b082cc1f50a24a67641f211970ce23885848f8adecd82
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"
---
# 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.

### 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: Intelligence Reports Advanced</td></tr></tbody></table>

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="d27563e57">Action </th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d27563e60">Limitation</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d27563e57 ">UI Preview</td>

            <td data-label="Limitation" class="slds-cell-wrap" style="vertical-align:top;" headers="d27563e60 ">
              <p>Timeout: 10 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="d27563e57 ">Download</td>

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

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

            <td data-label="Limitation" class="slds-cell-wrap" style="vertical-align:top;" headers="d27563e60 ">
              <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="d27563e57 ">Scheduled Export</td>

            <td data-label="Limitation" class="slds-cell-wrap" style="vertical-align:top;" headers="d27563e60 ">
              <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>