---
title: "Write a query (Query Editor)"
slug: "query-editor-v1"
updated: 2024-09-10T11:26:58Z
published: 2024-09-10T11:26:58Z
canonical: "documents.trocco.io/query-editor-v1"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documents.trocco.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Write a query (Query Editor)

## summary

TROCCO's Data Catalog supports the ability to write, execute, and save queries. You can also download the results of query execution in CSV file format.

              Warning about Queriedita

              

When refreshing a page, save the query first. **When you refresh the page in your browser, the query you had previously written will be erased.**

## How to use Queriedita

A query editor is opened by clicking on **Write Query** on the screen. Once you have selected a datastore name, you can begin writing queries immediately.

              GCP Project ID

              

If you are using a BigQuery datastore, select the project you wish to query with **the GCP project ID**.

## Features of Queriedita

### Multifunctional code editor

Automatic completion of table names is also supported, and the [logical name of the](/docs/catalog-glossary-v1#%E8%AB%96%E7%90%86%E5%90%8D) table in question is [also](/docs/catalog-glossary-v1#%E8%AB%96%E7%90%86%E5%90%8D) displayed [at](/docs/catalog-glossary-v1#%E8%AB%96%E7%90%86%E5%90%8D) completion. If the FROM clause is specified, the column names will be auto-completed thereafter.

![image](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/query-editor-v1-2024-08-29-11-30-0.png)

              If you are using the BigQuery version of Data Catalog

              

The following will also appear in the query editor

- Pop-tips on standard functions
- Syntax Error
- Amount of data processed when query is executed

### Editor display flexibility

Feel free to change the width of the queriedita. The query can be written with the table and column information adjusted to a size that is easy to reference. ![image](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/query-editor-v1-2024-08-29-11-30-1.png)

### Instant preview of query execution results

When a **query is executed**, a preview of the execution result is displayed directly below the query editor. As well as the [preview](/docs/table-information-v1#%E3%83%97%E3%83%AC%E3%83%93%E3%83%A5%E3%83%BC), it supports the display of summary statistics and the ability to sort and filter columns.

![image](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/query-editor-v1-2024-08-29-11-30-2.png)

### Save query execution results to CSV file

You can also download the execution results in CSV file format by clicking **Download Results**.

              
              

This specification is available only if you have selected the BigQuery version of Data Catalog.

              Query execution result download file size limit

              

The maximum file size of the CSV file that can be downloaded is **10 MB**. Lines that exceed the file size limit are truncated.

### Save the query

Click **Save Query** to save the query you have written. Click on a saved **query** to open the saved query.