Contents x
    Query Editor
    • 24 Jan 2023
    • Print
    • Dark
      Light
    • PDF
    Contents

    Query Editor

    • Updated on 24 Jan 2023
    • Print
    • Dark
      Light
    • PDF
    Article Summary

    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.
    image

    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.
    image

    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.
    image

    Download file size limit for query execution results

    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.
    image

    Was this article helpful?
    What's Next