Query Editor

Updated on 24 Jan 2023
1 Minute to read

Print
Share
Dark

Light

Note

This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.

summary

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

Precautions

When refreshing the page, save the query first.
- When you refresh the page in your browser, the query you were writing will be erased.

GCP Project ID

If you are using BigQuery, you can select the project to query by GCP project ID.

forte

You can always start writing right away

Every screen in the Data Catalog has a button to write a query.
You can easily start writing queries without going through annoying screen transitions.

Versatile code editor

Automatic completion of table names is also supported, and the logical name of the table is also displayed when completion.

In addition, the BigQuery version of the data catalog also displays:

ScreenTip for standard functions
Syntax Error
Data processing before query execution

Flexibility of editor display

You can freely change the width of the query editor.
You can adjust the table information and column information to a size that is easy to refer to, and then write a query.

Instantly preview query execution results

When you run a query, a preview of the execution results is displayed directly under the query editor.
Similar to previewing the catalog function, it also supports viewing summary statistics and sorting and filtering columns.