Contents x
    Write a query (Query Editor)
      • Print
      • PDF
      Contents

      Write a query (Query Editor)

        • Print
        • PDF
        Article summary

        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 table in question is also displayed at completion.
        If the FROM clause is specified, the column names will be auto-completed thereafter.

        image

        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

        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, it supports the display of summary statistics and the ability to sort and filter columns.

        image

        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.

        Was this article helpful?
        What's Next