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.
Updated 2 months ago