---
title: "Download query data"
canonical: "https://docs.devo.com/space/latest/95206208/Download%20query%20data"
format: markdown
---
> Macro (toc)
## Overview
After building your query, you can download its data in multiple formats. This is useful when you need to back up data before the data retention period expires, analyze data outside of Devo, or create specific graphics and reports.
## What permissions do I need?
Apart from the permissions required to run a search (see [Run a search using a finder](https://docs.devo.com/space/latest/94764298)), you also need the the *Data search download* permission (learn more about role permissions [here](https://devodocs.atlassian.net/wiki/spaces/latest/pages/94763681)).
## Performing the download
> Macro (rw-ui-steps-macro)
>
> > Macro (rw-step)
>
> First, select the period of time from which you need to download data using the time range selector.
>
> > Macro (rw-step)
>
> Click the **Download data** button on the search window toolbar (alternatively, you can select the options menu in the toolbar and click **Current query** → **Download** **data**).
>
> 
>
> 
>
> > Macro (rw-step)
>
> Choose the desired settings for the file in the **Download data** window:
>
> | **File name** | Enter a name for the file. |
> | --- | --- |
> | **Download settings** | Select the **Delivery** method for the data that you want to include in your file and the **Source** associated to that data:
- **Download immediately**: Allows you to select one of the options:
> - **Download current browser content** - Select this option to download only the data that has been downloaded to the browser, that is to say, data displayed in the search window.
> - **Download from server** - Select this option to download all the events from the query, including those that haven't been downloaded to the browser yet.
> ⚠️ **Heavy queries**
> > ⚠️
> > ⚠️ Note that the **Download from server** option is not meant to be used for heavy queries that would take a long time to process. In those cases, please use the options** Download to email **or **Download to S3**, explained below.
- **Execute the query in background**: you can choose to receive the results via:
> - **Attachment**: email with attachments.
> - **Download link (Amazon S3)**: Send the query data to the Devo S3 bucket (it is not possible to choose a different S3 bucket). You will receive the download URL in your user email.
> ℹ️ **Retention period in the Devo S3 bucket**
> > ℹ️
> > ℹ️ Downloaded data will be retained for a limited time, which varies depending on the cloud you’re using:
> > ℹ️
> > ℹ️ - US: 4 days
> > ℹ️ - CA: unlimited time
> > ℹ️ - APAC: unlimited time
> > ℹ️ - EU: 4 days |
> | **File format** | Format choices depend on the Delivery option.
- **CSV **- Downloads a .csv file where each event row value is separated by commas.
> - **TSV** - Downloads a .tsv file where each event row value is separated by a tab character.
> - **XLSX **- Downloads a .xlsx file where each event row corresponds to an event.
> - **JSON Object Array** - Downloads a .json file where each event is represented as an object.
> - **JSON Matrix **- Downloads a .json file where each event is represented as an array.
> - **Source **- Downloads a .txt file representing the events in their original format.
> ⚠️ The **Source **option isn't available for the following tables: `my.parser`; `my.synthesis`; or `my.tech`.
- **AVRO** - Downloads a .json file where each event is represented in a compact binary format.
> - **JSON Compact** - Downloads a .json file where each event has a more concise representation to reduce its size.
> - **JSON Simple** - Downloads a .json file where each event is represented as structured key-value pairs and ordered lists.
> - **JSON Simple Compact** - Downloads a .json file where each event is represented as structured key-value pairs and ordered lists in a compact format. |
> | **Date format** | Choose the required date format. |
> | **Time zone** | Specify the required time zone in the text field, or check the box to select the **GMT** timezone. |
>
> > Macro (rw-step)
>
> Click **Download** when you're done.
## Format Examples
- CSV
- TSV
- XLSX
*Binary data *
- JSON Object Array
- JSON Matrix
- AVRO
- JSON
- JSON Compact
- JSON Simple
- JSON Simple Compact