2023.01

2023.01

  • Imply
  • Ingest
  • Query
  • Visualize
  • Administer
  • Deploy

›Overview

Overview

  • Pivot overview
  • Datasources
  • SQL

Data cubes

  • About data cubes
  • Managing data cubes
  • Visualizations
  • Dimensions
  • Measures
  • Custom dimensions and measures
  • Time compare
  • Filter by measure
  • Annotations
  • Data export

Dashboards

  • Viewing dashboards
  • Creating dashboards
  • Managing dashboards

Alerts & Reports

  • Alerts
  • Scheduled reports

User access

  • Access control
  • User management in Pivot
  • Manage users with LDAP
  • Manage users with OIDC

Advanced features

  • Feature Flags
  • Customizing the Pivot UI
  • Generating links into Pivot
  • Monitor queries
  • Explain
  • CrossTab
  • Pivot server config
  • Plywood Expressions
  • Query parameters reference

Pivot API

  • Pivot API overview
  • Pivot users API
  • Pivot UserAuth API
  • Pivot user statuses API
  • Pivot roles API
  • Pivot connections API
  • Pivot data cubes API
  • Pivot dashboards API
  • Pivot alerts API
  • Pivot reports API

SQL

The SQL page in Pivot lets you query data sources from within Pivot using SQL:

SQL results

To run a query simply enter it into the SQL query box. You can make use of the auto complete feature and the schema on the left to compose your query. Then click Run. The results will appear in the results pane. You can now iterate on your query, share it, and download the results locally using the controls in the interface.

You can use the explain feature to view the query plan for a given SQL query. To do so, select Explain query from the ellipses menu ....

If user management is enabled in Pivot (the default in Cloud Imply), users need to have AccessSQL permissions to view or use the SQL interface.

Note that Pivot SQL underlies Pivot SQL data cubes. You can use SQL to create expressions for custom dimensions and measures. For more information, see Pivot SQL data cubes.

More information

For much more information on Druid SQL, including details on its features and syntax, see the Druid SQL documentation.

Last updated on 2/3/2022
← VisualizationsAbout data cubes →
  • More information
2023.01
Key links
Try ImplyApache Druid siteImply GitHub
Get help
Stack OverflowSupportContact us
Learn more
Apache Druid forumsBlog
Copyright © 2023 Imply Data, Inc