Getting Started with SQL Analytics

Run SQL queries, create charts, and review dashboards to gain valuable insights within your indexed data.

In the ChaosSearch console, click SQL Analytics to navigate to the Superset interface.

2734

To run a basic SQL query:

  1. Click SQL Lab > SQL Editor to open the SQL query page.
2734
  1. To see results from a view, you can do one of the following steps:
  • In the left menu, select chaos in the Schema field, and select a Refinery view in the See Table Schema field. The window updates to display records from that view in the lower right Preview area.
2734
  • In the top query constructor area, type or paste a SQL query to run. Click Run to see the results in the lower right Preview area.
2734

Charts and Dashboards

Some users might have pre-built charts and dashboards that offer graphical or tabular representations of data analysis for their log and event files, built by ChaosSearch Customer Success or by their customer data analysts.

Click the Superset logo to return to the Home page to check for pre-built charts or dashboards that you can use. The following image is a sample dashboard of orders data:

3380

Creating charts and dashboards can take some time and practice for new users to learn, especially for developing the analytics that support them. The Superset interface offers guidance to help with the process for creating them.