›Analytics

Get started

  • Introduction to Imply Polaris
  • Quickstart
  • Navigate the console
  • Key concepts

Data

  • Overview
  • Create a schema
  • Data partitioning
  • Introduction to rollup
  • Replace data
  • Supported data formats

Analytics

  • Overview
  • Manage data cubes
  • Visualize data
  • Dimensions
  • Measures
  • Dashboards
  • Visualizations reference
  • Query data

Monitoring

  • Overview

Management

  • Overview

Billing

  • Overview
  • Polaris plans
  • Estimate project costs
  • Manage billing and payments

Security

  • Overview
  • Add users to an organization
  • User roles reference
  • Manage user groups
  • Enable SSO
  • SSO settings reference

Developer guide

  • Overview
  • Authenticate API requests
  • Create a table
  • Get table ID
  • Define a schema
  • Upload files
  • Ingest to table
  • Push event data
  • Query data
  • Link to BI tools
  • Connect over JDBC

API reference

  • Overview
  • Reference index
  • Events API
  • Files API
  • Ingestion Jobs API
  • Ingestion Templates API
  • Performance API
  • Query API
  • Tables API
  • Common object definitions

    • Table
    • TableRequest
    • RollupSchema
    • IngestionJobSpec
    • CsvFormatSettings
    • JsonFormatSettings
    • TimestampMapping

Product info

  • Release notes
  • Known limitations

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

  • Query data using the API
← Visualizations referenceOverview →
  • Prerequisites
  • Access the SQL editor
  • Learn more
Key links
Try ImplyApache Druid siteImply GitHub
Get help
Stack OverflowSupportContact us
Learn more
BlogApache Druid docs
Copyright © 2022 Imply Data, Inc