Query data

After you have created a table and ingested data, you can start running SQL queries against the data in the Imply Polaris console. The SQL editor IDE provides a user interface for building and running queries.

This topic explains how to query data in the Polaris console. For information on how to query data programmatically, see Query data by API.

Prerequisites

The AdministerQueries role is required to issue new SQL queries as well as manage and view any saved queries. For more information on user roles, see User roles reference.

Access the SQL editor

You can access the SQL editor as follows:

  1. Click SQL in the left navigation menu.

  2. Select your table from the list of available tables.

  3. Hover over the data field you want to query by and click the blue arrow icon that appears.

    Polaris SQL editor

  4. Click Run.

  5. Polaris displays the results in the QUERY RESULT panel.

You can also access the SQL editor from the table details page. To do so, from the table details page, click Explore table in the top-right corner. Select SQL editor from the list menu options.

Learn more

← Visualizations referenceOverview →