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.
![](https://files.readme.io/c4f4ca9-SQL-Reference-V2.jpg)
Updated 9 months ago