Soracom Lagoon

Visualize Soracom Query Results in Soracom Lagoon

You can visualize Soracom Query results in Soracom Lagoon 3. In this guide, we'll visualize the results that were generated in Using Query to Show Recent Connection Trends.

Prerequisites

Step 1: Create a New Dashboard and Panel

  1. Log in to the Lagoon console and click Dashboards icon > New > New Dashboard.

    https://g-v3.lagoon.soracom.io

    New Dashboard menu in Lagoon console

    A new dashboard named "New dashboard" will be created.

  2. Click Add a new panel.

    https://g-v3.lagoon.soracom.io

    Add new panel button in dashboard

    A panel will be created and the "Edit Panel" screen will appear.

    https://g-v3.lagoon.soracom.io

    Edit Panel screen interface

  3. Select Soracom Query from the Query tab.

    https://g-v3.lagoon.soracom.io

    Soracom Query selection in Query tab

  4. Enter the SQL query.

    For details on the query, refer to Create a Query with SQL Assistant.

    https://g-v3.lagoon.soracom.io

    SQL query input field with session data query

    SQL character limit: The maximum length for SQL queries is 3,000 characters. If your query exceeds this limit, an error will occur. Reduce the number of characters to stay within the limit.

  5. Click Run or press Shift + Enter to execute the SQL query.

    https://g-v3.lagoon.soracom.io

    Apply button to execute the query

API calls are counted: When executing Soracom Query from Soracom Lagoon, API calls count toward your plan's total usage. Some plans limit the number of API calls or charge fees based on usage. For details, see View Usage.

Time range limitation: The time range specified in your SQL query may be limited by the time range set in the panel. For example, if your query retrieves data for the past 2 hours but the panel time range is set to 1 hour, only 1 hour of data will be displayed.

No Harvest Data export charges: Retrieving data from Soracom Harvest Data using Soracom Query does not incur export charges. This applies even if the Harvest Data retention period extension option is enabled.

Step 2: Set the Panel Title

By default, "Panel Title" is displayed.

  1. Click All > Panel options and enter "Session Creation Count Trend for the Last 24 Hours" in the Title field.

    https://g-v3.lagoon.soracom.io

    Panel title configuration field

Step 3: Save the Dashboard

  1. Click Apply on the "Edit Panel" screen.

    https://g-v3.lagoon.soracom.io

    Legend configuration options

    You'll return to the Dashboard screen.

  2. Click the Save dashboard button.

    https://g-v3.lagoon.soracom.io

    Save dashboard dialog

    The Save dashboard screen will appear.

  3. Enter a name for the Dashboard (e.g., Session Creation Count Trend Dashboard) in the Dashboard name field and click Save.

    https://g-v3.lagoon.soracom.io

    Final dashboard with session trend chart

    The Dashboard will be saved.