NIMORO Probe

Prev Next

Available in VPC

NIMORO Probe provides a fast query experience and an analysis environment so you can write SQL that fits your conditions and context to analyze service data in depth.

Note
  • For customer data analytics services, NIMORO Probe saves query result files to the Object Storage bucket you specify. For NAVER data analytics services, you can also download query result files; they are stored in an HDFS /user/nimoro/probe path in the Data Box’s Hadoop cluster.
  • You need to check the following items before running SQL in NIMORO Probe:
    • Check if the schema is loaded in Data Catalog.
    • Check if the DB or table you want to view has necessary permissions.

NIMORO Probe interface

The NIMORO Probe interface includes the following components:

nimoro-probe-vpc_screen_query_editor_ko

Component Description
① Menu name Current menu name.
② Connector Select the connector to query from a dropdown.
  • Trino: Faster than the Hive connector.
  • Hive: Slower but stable for analyzing large datasets.
Query Editor Enter query (see Query Editor).
Saved Query Frequently used query list (see Saved query).
Sample Query Sample query list (see Sample query).
Recent Query Recent query list (see Recent query).
⑦ Databases and tables
  • Table list: Browse databases, tables, and columns you’re allowed to access.
  • My temp: View tables created in the Temp DB. You can extract just the data you need and create compact analysis tables.
    • This is available only if a service manager Configure temp DB for the connector.
    • When you create a table with the Trino connector, you must include required conditions in the WITH clause.
    • Only the table creator can view the table. Unless Data Catalog permissions were granted for viewing temp DB.
  • i-nimoro_refresh: Click to update the table and the DB list.
⑧ Query input box Enter SQL query.
  • You cannot run more than one statement at the same time.
  • Standard service DB: Only allows SELECT permission.
  • My temp DB: Allows SELECT, CREATE, INSERT, UPDATE, DROP, and ALTER permissions.
  • The exact scope depends on each cluster’s engine settings and version.
RUN Click to execute the query with your conditions.
  • The run is saved to Recent query so you can check status and download results.
Explain Click to view the execution plan you wrote.
Save as Click to Save query with a new name.
Clear Click to reset conditions.
⑬ Query results Shows the dataset returned by your query.
Note

For NAVER data analytics services, the Trino connector currently does not support INSERT into Temp tables.
Support will be added in a future Trino upgrade.

Run Query Editor

To analyze data by writing SQL:

  1. Access the NIMORO platform (see Access NIMORO platform).
  2. Click i-nimoro_probe (NIMORO Probe) in the left menu.
    • [Query Editor] opens by default.
    • If another NIMORO Probe page is open, click [Query Editor].
  3. Select the connector to analyze from the dropdown.
  4. Write the SQL you need in Query Editor.
    • Click [Explain], [Save as], or [Clear] as needed to view, save, or initialize information. For details about each button, see Query Editor interface.
  5. Click [RUN].

Query Editor interface after query run

The Query Editor interface after a query run includes the following components:

nimoro-probe-vpc_screen_query_editor_after_ko

Component Description
① Query results
  • Query result: Shows the dataset returned by your query.
  • Query: Shows the query you entered.
  • You can view up to 1,000 results on screen; download the result file to see all results.
  • In Recent query, you can download and view results for 72 hours after execution; history is available for 30 days.
  • For customer data analytics services, results are saved to the Object Storage bucket you specified.
  • For NAVER data analytics services, you can also download query result files; they are stored in the HDFS path in the Data Box’s Hadoop cluster.
Download Click to download the result file.
  • Files are available as CSV or TSV and can be downloaded up to 100 MB.
  • For very large result sets, file generation can take time, and files over 100 MB may not be downloadable.
  • For customer data analytics services, results are saved to the Object Storage bucket you specified.
  • For NAVER data analytics services, you can also download query result files; they are stored in the HDFS path in the Data Box’s Hadoop cluster.
Note

When you download as a CSV file, fields that contain commas (,) may appear split into multiple columns in spreadsheet tools such as Excel. We recommend downloading in an Excel format when available.

Saved Query

You can query data using your saved queries.

Saved query interface

The saved query interface includes the following components:

nimoro-probe-vpc_screen_saved_query_ko

Component Description
① Menu name Current menu name.
② Search bar Filter by query name or contents.
③ Category areas List of saved query categories.
④ Query list View the list of saved queries.
  • Click Sort by to sort by Recently edited or Name (A–Z).
RUN Click to open the query view page.
⑥ Additional features i-nimoro_more: Click to Edit query or Delete query.

Add category

To add a category in Saved query:

  1. Access the NIMORO platform (see Access NIMORO platform).
  2. Click i-nimoro_probe (NIMORO Probe) in the left menu.
  3. Navigate to Saved query > Add category.
  4. Enter the category name.
  5. Click [Save].

Edit category name

To rename a category in Saved query:

  1. Access the NIMORO platform (see Access NIMORO platform).
  2. Click i-nimoro_probe (NIMORO Probe) in the left menu.
  3. Click i-nimoro_edit1.
  4. Edit the category name.
  5. Click [Save].

Delete category

To delete a category in Saved query:

Note

You cannot delete a category that contains one or more queries. Empty the category first.

  1. Access the NIMORO platform (see Access NIMORO platform).
  2. Click i-nimoro_probe (NIMORO Probe) in the left menu.
  3. Click i-nimoro_edit > i-nimoro_delete Delete Category.

Edit query

To edit a saved query in Saved query:

  1. Access the NIMORO platform (see Access NIMORO platform).
  2. Click i-nimoro_probe (NIMORO Probe) in the left menu.
  3. Click i-nimoro_more > i-nimoro_edit Edit on the right side of the query to edit.
  4. When the edit interface opens, update the information.
    • Category: Change category
    • Title: Enter the query name to edit.
    • Write query: Enter the updated query.
    • Descriptions: Enter the updated query.
  5. Click [Save as] or [Save].
    • [Save as]: Save as a new query after editing.
    • [Save]: Overwrite the existing query after editing.

Delete query

To delete a query in Saved query:

  1. Access the NIMORO platform (see Access NIMORO platform).
  2. Click i-nimoro_probe (NIMORO Probe) in the left menu.
  3. Click i-nimoro_more > i-nimoro_delete Delete on the right side of the query to edit.
  4. Click [Delete].

Save query with a new name

To save a query with a new name:

  1. Access the NIMORO platform (see Access NIMORO platform).
  2. Click i-nimoro_probe (NIMORO Probe) in the left menu.
  3. In Query Editor, Sample query, or Recent query, click [Save as].
  4. When the query save popup window appears, enter and select the information.
    • Query title to save: Enter a query title to save.
    • Select category: Select a category to save the query to.
      • Click [Save to new category] to create a category if necessary.
  5. Click [Save].

Sample query interface

The sample query interface includes the following components:

Note

Sample query provides sample queries created in the NIMORO Studio menu. For more information, see Probe Manage > Sample query from NIMORO Studio.

nimoro-probe-vpc_screen_sample_query_ko

Component Description
① Menu area Current menu name and description.
② Search bar Filter by query name or contents.
③ Categories List of sample query categories.
④ Sample query information Sample query title and content.
Share Click to copy the sample query URL.
Save as Click to Save query with a new name.
RUN Click to open the query view page.

Recent query interface

The recent query interface includes the following components:

nimoro-probe-vpc_screen_recent_query_ko

Component Description
① Menu name Current menu name.
② Search bar Filter by query name or contents.
③ Recent wizards List of recently used wizards.
Save as Click to Save query with a new name.
RUN Click to open the query view page.