SQL Syntax Support

A summary of the SQL syntax available within ChaosSearch SQL Analytics

The ChaosSearch SQL syntax and SQL Analytics query support currently uses the Trino SQL dialect, with some modifications for read-only querying of the Chaos Index® data and Refinery views. The SQL Analytics portal can be used to run the following subset of statements:

  • SELECT ...

  • SHOW COLUMNS FROM <table>;

  • SHOW TABLES ...;

The SQL API also supports listing the information using queries to read information_schema.tables and information_schema.columns so that permitted users can explore them with a select * from information_schema.<relation> command.