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 5 months ago