- 24 Jan 2023
- 1 Minute to read
-
Print
-
DarkLight
Query Editor
- Updated on 24 Jan 2023
- 1 Minute to read
-
Print
-
DarkLight
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.
- When refreshing the page, save the query first.
- When you refresh the page in your browser, the query you were writing will be erased.
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.
Save query execution results to CSV file
This specification applies only when using BigQuery.
You can also download the execution result in CSV file format by clicking Download result.
The file size of the CSV file that you can download is up to 10MB.
Lines that exceed the file size limit are truncated.
Query saving function
You can save the query that you wrote. You can reopen it from a saved query.