Soracom Query

Using Query to Create a Billing Report

Execute a sample query in Soracom Query to display historic monthly billing total.

Prerequisites

You must be subscribed to a Soracom Query plan. For details, see Plan Management.

Step 1: Access Soracom Query

  1. Login to the User Console.

  2. From the Menu, expand Soracom Query and select Soracom Query.

    https://console.soracom.io

  3. Click Launch Soracom Query Studio.

    https://console.soracom.io

  4. Click Advanced.

    https://query.soracom.io

Step 2: Execute a Sample Query

  1. Click Monthly billing total in the Samples section.

    https://query.soracom.io

  2. When the SQL query is displayed, click Run Query.

    https://query.soracom.io

The maximum character limit for SQL queries is 3,000 characters.

If your SQL query exceeds 3,000 characters, an error will be thrown. If you have exceeded the limit, reduce the number of characters in your SQL query within the allowable amount.

  1. The SQL execution results will be displayed.

    https://query.soracom.io

If you want to edit the SQL for other parameters, use the editor to make your changes and click Run Query again

For instructions on using the SQL Assistant to help generate SQL, refer to the Show Recent Connection Trends example.