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:
SHOW COLUMNS FROM <table>;
SHOW TABLES ...;
The SQL API also supports listing the information using queries to read
information_schema.columns so that permitted users can explore them with a
select * from information_schema.<relation> command.
Updated about 1 month ago