---
schema_version: "1"
id: 83ece1d219cb7ab08b1244d6e116682e2bed40069851f03e9d32913e85fc7604
title: Export Query Results
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_export.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_data_lakes_query_export.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: a7d074f6bcd0f0e56f9176c15ed90a88b666c89bc2e6736ec28141f157080ee2
description: You can download or export query results to S3, SFTP, Google Cloud Platform, Azure Blob, or email and define an ongoing schedule.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Export Query Results

You can download or export query results to S3, SFTP, Google Cloud Platform, Azure Blob, or email and define an ongoing schedule.

### 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="d55847e38">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d55847e38 ">To export query results:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d55847e38 ">Admin</td>

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

1. From the **Connect & Mix** tab, select **Granular Data Center**, and then **Query Granular Data**.
2. Create a query or select a saved one.
3. Run the query.
4. To download the query results locally, select **Download**. Only the first 20,000 rows are downloaded.
5. To export all the data, click **Export To** and select the format.
    
    ![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
    
    - If you select Email, by default the file format is CSV Friendly Formatting.
    - In general, for all export formats, CSV Friendly Formatting is limited to 2.3M rows in the results.
6. To export on a scheduled basis, click **Scheduled Export**. The options change according to the format you select. After you set the delivery method and enter your credentials, set the frequency. For example, set daily to export the results on a daily basis.